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