MySQL Forums
Forum List  »  Newbie

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 ?

BV Larsen

Options: ReplyQuote

Written By
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.