Multiple LEFT JOIN SQL syntax in msaccess
| From: | Emile Bosch | Date: | Fri, 24 May 2002 15:30:30 +0000 |
| Subject: | Multiple LEFT JOIN SQL syntax in msaccess | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-99090@lists.php.net to get a copy of this message | ||
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