OMG i solved it already! $q="SELECT * FROM ((salad a LEFT JOIN salam g ON a.adgrpnum = g.amgrpnum) LEFT JOIN salmk m ON a.admrknum = m.mkmrknum) WHERE a.adartnum=$adartnum"
Tadaaa! Thx pong for giving me the tip about the ( 's !! "Emile Bosch" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Yes, i know i am offtopic but i just don't want to that scary M$newsgroups > so can please tell me how i can > have 2 left joins in a queryresult? > > this doesn;t work in msaccess > > $q="SELECT * FROM salad a > LEFT JOIN salam g ON (a.adgrpnum = g.amgrpnum), > LEFT JOIN salmk m ON (a.admrknum = m.mkmrknum) > WHERE a.adartnum=$adartnum"; > > this neither: > > $q="SELECT * FROM salad a > LEFT JOIN salam g ON a.adgrpnum = g.amgrpnum, > LEFT JOIN salmk m ON(a.admrknum = m.mkmrknum > WHERE a.adartnum=$adartnum" > > so does someone know how i do a good left join > > Thx mate! > > Mielz > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php