Access SQL Question?

[dominover]

Can anyone tell me what is wrong with this statement.

SELECT [Table2].[Field2], WHERE [Table2].[ID] = [TABLE1].[ID];

Access tells me there's a syntax error and I'm not sure what rule I've broken despite obsessive googling.

[NTC]

make the query using the visual query design; dragging the tables in, making the join line, and adding the field - - run it so it returns the record set that is correct.... then select 'SQL View' this is the certain way to answer your question

[jeffatwork]

I believe you are are missing the "From" and some parenthesis

SELECT Table2.Field2
FROM Table1, Table2
WHERE (((Table2.id)=[Table1].[ID]));

[dominover]

Thanks both. It was the FROM that was missing. Works fine now.