Post your exeact code you are using. I assume it looks something like:
lnRetVal = SQLExec(lnHandle, "SELECT * FROM dataA, DataFirma where dataA.ID(+) = dataFIRMA.FIRMID", "crsResults")
The syntax I gave you is correct for a LEFT or RIGHT join for Oracle. Also, are you sure about the version of Oracle? The latest release of Oracle is 9. Did you mean version 8.1.6?
>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
Mark McCasland
Midlothian, TX USA