Posted by ZeldorBlat on 10/30/05 17:49

>It should only get the records from t2 which have
>t2.statusid=t1.statusid AND t2.shipref=t1.shipref ...but this doesnt
>seem to work with the left outer join...

select t2.*, t1.flag
from table2 t2
left outer join table1 t1
on (t2.statusid = t1.statusid
and t2.shipref = t1.shipref)

• Next in forum: PHP and MySQL
• Prev in forum: Re: Get ID's from two different tables
• Thread view: Re: Get ID's from two different tables

[Reply to this message]