MySQL - Left Join Question
| From: | Monty | Date: | Wed, 26 Jun 2002 03:39:57 +0000 |
| Subject: | MySQL - Left Join Question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20121@lists.php.net to get a copy of this message | ||
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?