Re: MySQL - Left Join Question
| From: | Jason Wong | Date: | Wed, 26 Jun 2002 03:47:39 +0000 |
| Subject: | Re: MySQL - Left Join Question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20122@lists.php.net to get a copy of this message | ||
On Wednesday 26 June 2002 11:39, Monty wrote:
> A LEFT JOIN B
> ON a.id = b.id
>
> If I issue the above MySQL SELECT condition and there is more than one
> record in B that could potentially be joined to a record in A, is there a
> way to tell MySQL which of the two records from B to choose for the join
> with A?
Add more criteria to your query until the results returned are the ones you
want.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
It's never too late to have a happy childhood.
*/