Multiple LEFT JOIN SQL syntax in msaccess

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