SQLExecQuery link database tables

[MPullen]

I've trying to retrieve data from our database using SQLExecQuery.
I'm having trouble with the formula to link tables together.
So far I've tried as follows, but it doesn't work:
SQLExecQuery DB, "SELECT CLIENTS.NAME, CLIENTS.TEL_1, LEASES.START_DATE FROM ONSETC_MERGED_CLIENTS INNER JOIN ONSETC_MERGED_LEASES ON ONSETC_MERGED_CLIENTS.CLIENT_ID = ONSETC_MERGED_LEASES.CLIENT_ID WHERE LEASES.LEASE_ID = '1234'"

I'm not sure on the INNER JOIN part.
Is this the correct formula?

Any help would be much appricated.

 

[MPullen]

I've just tried a different formula, but still no success!
SQLExecQuery DB, "SELECT CLIENTS.NAME, CLIENTS.TEL_1, LEASES.START_DATE FROM ONSETC_MERGED_CLIENTS CLIENTS, ONSETC_MERGED_LEASES LEASES WHERE LEASES.CLIENT_ID = CLIENTS.CLIENT_ID AND LEASES.LEASE_ID = '1234'"

Please help!

 

[Joe Was]

DatabaseName = "SELECT CLIENTS.NAME, CLIENTS.TEL_1, LEASES.START_DATE FROM ONSETC_MERGED_CLIENTS INNER JOIN ONSETC_MERGED_LEASES ON ONSETC_MERGED_CLIENTS.CLIENT_ID = ONSETC_MERGED_LEASES.CLIENT_ID WHERE LEASES.LEASE_ID = '1234'"
queryString = _
"SELECT * FROM product.dbf WHERE (product.ON_ORDER<>0)"
myJoin = SQLOpen("DSN=" & DatabaseName)
SQLExecQuery myJoin, queryString
Set output = Worksheets("Sheet1").Range("A1")
SQLRetrieve myJoin, output, , , True
SQLClose myJoin

I cannot test this, but "DatabaseName" may need to be the result of your join within the database product. So, DatabaseName is not a join statement but the table name of the resulting join. You cannot use SQLExec without SQLOpen! Hope this helps? JSW

 

[MPullen]

I've sorted it.
Apparently there's a limit of 127 characters for the string.