Re: Multiple LEFT JOIN SQL syntax in msaccess
| From: | Emile Bosch | Date: | Fri, 24 May 2002 15:55:51 +0000 |
| Subject: | Re: Multiple LEFT JOIN SQL syntax in msaccess | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-99091@lists.php.net to get a copy of this message | ||
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" <emilebosch@hotmail.com> wrote in message
news:20020524152940.32569.qmail@pb1.pair.com...
> 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
>
>
>