Hi this is my first message
sorry for my terrible english, i'll try to write correctly! :-)

I got this trouble:
it seems to be an error in FROM of this query but i'm unable to find it, can you help me?

SELECT tabA.field1, tabA.field2, tabA.field3, tabB.field1, tabB.field2, tabB.field3 FROM tabA IN 'D:\Dati\......\listino.mdb' LEFT JOIN TabB ON (TabA.field4 = tabB.field4) WHERE tabA.field5 = 'X' AND tabA.field6='Y' AND tabB.field5= 'Z'

the connection is made on database that contains TabB (that's why I'm using "FROM tabA IN 'physical path of database that contains tabA')

IMPORTANT: If i remove the left join it works correctly....

suggestions? tips? tricks?
thank you
bye

I don't see where tabA is ever defined in your SQL statement.

So here is a guess - you may want to try something like this (AS tabA is added to what you already had):

SELECT tabA.field1, tabA.field2, tabA.field3, tabB.field1, tabB.field2, tabB.field3 FROM tabA IN 'D:\Dati\......\listino.mdb' AS tabA LEFT JOIN tabB ON (tabA.field4 = tabB.field4) WHERE tabA.field5 = 'X' AND tabA.field6='Y' AND tabB.field5= 'Z'

uh, I already solved my troubles splitting the query in 2 queries....
I think I tried even to write "AS tabA", as you suggested, with the same result...
thank you however
bye