Hallo,
what means that to the RIGHT JOIN SYNTAX:
SELECT * FROM dataA, DataFirma where dataA.ID(+) = dataFIRMA.FIRMID

It makes no difference
SELECT * FROM relACP RIGHT JOIN relFIRMA ON relACP.MNR = relFIRMA.FIRMANR
or
SELECT * FROM relACP RIGHT JOIN relFIRMA ON relACP.MNR = relFIRMA.FIRMANR
the odbc error is the same:
sql command not properly ended.

the database is oracle 1.6

could it be that oracle 1.6 not supportet the "LEFT RIGHT JOIN" Syntax ?

achim