Re: MySQL - Left Join Question

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?