Re: Multiple LEFT JOIN SQL syntax in msaccess

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@xxxxxxxxxxx> wrote in message
news:20020524152940.32569.qmail@xxxxxxxxxxxxxxx
> 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