[Hidden-tech] Mind Puzzle For All You SQL Gurus

Mark Bucciarelli mark at hubcapconsulting.com
Fri Dec 16 15:54:38 EST 2005


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




Google

More information about the Hidden-discuss mailing list