Hi all,

Thursday, July 04, 2002, I wrote:

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

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

MG> TABLE_1 references TABLE_2 via a FK.
MG> IBAccess says:
MG> UNEXPECTED END OF COMMAND
MG> What's wrong?
MG> What's missing?

I missed the ON statement, sorry!
I thought it was a kind of NATURAL JOIN but it seems it doesn't exist
in FB.


Kind regards,
--
Matteo

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