URGENT LEFT JOIN

[andi nies]

hi NG

i'm kinda familiar with left joins and so on but if some serious problems with some outer joins the last couple days and didn't find a soloution.

so herer is the thing...

i'm mapping different paymentoptions to a contract (c.o.d. or credit card e.g.) and this for each country... but when one contract choosed a option it is not avaiable for the others. so i tought RIGHT OUTER means for every option, so that atleast any option is avaiable even if its NULL, right?

Code:

SELECT * FROM countries LEFT OUTER JOIN paymentOptionToContract ON countries.cou_id = paymentOptionToContract.ptc_country RIGHT OUTER JOIN paymentOptions ON paymentOptionToContract.ptc_paymentoption = paymentOptions.pym_id WHERE paymentOptionToContract.ptc_contract = $currentContract->con_id || paymentOptionToContract.ptc_contract IS NULL ORDER BY cou_name,pym_id



so if some one could tell me WHY da heck this mysql ignors the OUTER RIGHT.

sorry for my "maybe" bad english

so thanks alto for any help!!!

andy