You might think about adding comparison operators to the statement to 
help narrow the search.

        i.e.  A LEFT JOIN B
              ON =
              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:

> ON =
> 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 (
To unsubscribe, visit:

Reply via email to