You might think about adding comparison operators to the statement to
help narrow the search.
i.e. A LEFT JOIN B
ON a.id = b.id
WHERE a.value = b.value
AND a.value2 = b.value2
OR a.value3 = b.value3
The MySQL website provides documentation dealing with comparison
operators and the WHERE statement.
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?
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
