Need help with {oj... LEFT OUTER JOIN.... ?
Posted by:
BV Larsen
Date: March 15, 2006 11:40AM
Hi !
I have just migrated an app to MySQL 5. It connects through a ODBC (ODBC driver 3.51) connection to MySQL srv 5.
It sends the server the following statement:
SELECT DISTINCT telefonnummer.snr, telefonnummer.telefonnr, telefonnummer.fysisk, abonnent.navnbruker,
abonnent.gradtittel, abonnent.avdeling, abonnent.privattlfnr, abonnent.stillingfunksjon FROM {oj {oj telefonnummer LEFT OUTER JOIN abotlfnr ON telefonnummer.snr = abotlfnr.snr AND telefonnummer.telefonnr = abotlfnr.telefonnr} LEFT OUTER JOIN abonnent ON abotlfnr.abonnentid = abonnent.abonnentid} ORDER BY telefonnummer.telefonnr ASC
Can anybody spot the problem ? and tell if there is a way to make the server accept this or show me how the sql-statement should be in order to work ?
Regards
BV Larsen
Subject
Written By
Posted
Need help with {oj... LEFT OUTER JOIN.... ?
March 15, 2006 11:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.