Forums

Thanks for your reply ghosttie. I have no control over the data formats. When I bring them into any software, say MS Access for example, the formats always end up the same and I can join the tables on those fields without issue, it only seems to be during an SQL Join that they don't match, and only ...

Okay, we're nearly up to 300 views without any help.

I am happy for any suggestion, no matter how silly it may be.

Is there not anyone out there that can answer this question, please?

I have the following SQL query to extract data from a Jade database using ODCB.

SELECT
Table1.Field1,
Table1.Field2,
Table1.Field3,
Table1.Field4,
Table2.Field5
FROM Table1, Table2
Where Table1.Field6 = Table2.Field7;

It returns zero rows even though there is data in both tables and Field6 and ...