MySQL Query Example/Solution of Oracle Query

[M Riaz Bashir]

Hi, Please let me know the solution of mentioned Oracle Query, that how can I use the same in MySQL.

SELECT A.CNAME, B.ANAME FROM CLIENT A, DEALER B
WHERE A.CCODE=B.ACODE(+)

Thanks (Riaz)

[Lost User]

Which part did not work? What error did it throw?

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[Jorgen Andersson]

MySql doesn't do implicit outer joins, you'll have to do the full ANSI syntax instead.

SELECT. A.CNAME, B.ANAME
FROM CLIENT A,
LEFT OUTER JOIN DEALER B
ON A.CCODE = B.ACODE

Wrong is evil and must be defeated. - Jeff Ello (√-shit)2

[Lost User]

..that's what the plus does? Nice :)

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[Jorgen Andersson]

Yeah, but note that the plus isn't on the outer side. It marks the side with the nulls.

Wrong is evil and must be defeated. - Jeff Ello (√-shit)2

[M Riaz Bashir]

thank you sir

[Jorgen Andersson]

You're welcome.

Wrong is evil and must be defeated. - Jeff Ello