Matteo Giacomazzi schrieb:

>
> 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;

Join ON what?
You just forgot to define the join condition.


SELECT TABLE_1.FIELD_1, TABLE_2.FIELD_2
FROM TABLE_1 INNER JOIN TABLE_2 ON TABLE1.SOMEFIELD =
TABLE.SOME[OTHER]FIELD;

Luc.