the syntax is:

select ... from table1 inner join table2 on table1.field1 = table2.field1;

the join *needs* a condition.
see the manual or sql ref.

> -----Original Message-----
> From: PUB: Matteo Giacomazzi [mailto:matteo.giacomazzi@...]
> Sent: Jueves, 04 de Julio de 2002 13:38
> To: ib-support@yahoogroups.com
> Subject: [ib-support] lost with JOIN
>
>
> 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
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Free $5 Love Reading
> Risk Free!
> http://us.click.yahoo.com/Pp91HA/PfREAA/Ey.GAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>