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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only