Put your select here to us. With it we can help you better. "Scott Haneda" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > Mysql 4.x > > I have a one to many case, key is `id`, in this case, I have tables users > and transactions. > > A user can have 1 to x transactions, each transaction has a status to it > as > well. I want to be able to get users where there is a transaction status > of > 'wells', however, there can be more than one of those transactions, all I > care is that it exists and I just want one unique user record back. > > Ie: if I have 100 users, and each user has 2 transactions of type 'wells', > I > want to select those, but a regular join will send me back 200 records, > where I want only 100 > > Can someone point me in the direction of the correct join to make this > happen. > -- > ------------------------------------------------------------- > Scott Haneda Tel: 415.898.2602 > <http://www.newgeo.com> Novato, CA U.S.A. > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
