Board index » delphi » MS Access SQL syntax problem

MS Access SQL syntax problem


2007-03-12 10:15:25 AM
delphi196
Hi,
Can someone tell me what is my problem or what should be the correct syntax
in Access 2003 please:
SELECT Table1.Name
FROM Table1
INNER JOIN Table2 ON Table1.Name = Table2.Name
WHERE Table1.ID = 123
Thanks
 
 

Re:MS Access SQL syntax problem

Try the next SQL-statement:
SELECT Table1.Name
FROM Table1, Table2
WHERE (Table1.ID = 123)
AND (Table1.Name = Table2.Name)
"Alan T" <XXXX@XXXXX.COM>writes
Quote
Hi,
Can someone tell me what is my problem or what should be the correct
syntax
in Access 2003 please:

SELECT Table1.Name
FROM Table1
INNER JOIN Table2 ON Table1.Name = Table2.Name
WHERE Table1.ID = 123

Thanks