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