Hi all,

I cannot understand what's wrong in a query like this:

SELECT TABLE_1.FIELD_1, TABLE_2.FIELD_2
FROM TABLE_1 INNER JOIN TABLE_2;

TABLE_1 references TABLE_2 via a FK.
IBAccess says:
UNEXPECTED END OF COMMAND
What's wrong?
What's missing?
I checked in the manual but it seems this is the correct syntax!

I need JOIN to create a view, but if I cannot write even a simple
query......

Thank you!

Kind regards,
--
Matteo

mailto:matteo.giacomazzi@...
ICQ# 24075529