On Wed, Dec 14, 2005 at 11:47:10AM -0500, Jeremy Dunn wrote: > If there are multiple rows in B for the same sortfield value, for the > same row in A, then you can do something to limit the row to the first > one returned (syntax varies by database), e.g. "order by b.pkfield > limit 1;" . Ah, a MySql user. ;) m