SELECT * FROM dataA, DataFirma where dataA.ID(+) = dataFIRMA.FIRMID

The (+) goes on the [deficient] table that would have NO child records to match the parent record in the table without the (+). If DataA is the parent table:

SELECT * FROM dataA, DataFirma where dataA.ID = dataFIRMA.FIRMID(+)

>Hallo,
>i make an odbc connection to an oracle 8 database
>the sql statement:
>SELECT * FROM dataA RIGHT JOIN dataFIRMA ON dataA.ID = dataFIRMA.FIRMID
>gives the error:
>
>SQL Command not properly ended.
>
>any ideas ?
>
>tia