SELECT blablabla FROM blabla GROUP BY ID Try...
Cheers Marco On Mon, 13 Dec 2004 13:59:34 -0000, James Smith <[EMAIL PROTECTED]> wrote: > Ok, heres the thing. I have a table (actually multiple tables joined but > for simplicity here we will call it one table) that looks something like... > > ID ISBN > -- ---- > 1 1 > 2 1 > 3 1 > 4 1 > 5 2 > 6 2 > 7 2 > 8 3 > 9 4 > 10 4 > 11 4 > 12 1 > 13 5 > > In the results I need no more than 2 of any ISBN, so for the above data I > need the results of the query to look like... > > ID ISBN > -- ---- > 1 1 > 2 1 > 5 2 > 6 2 > 8 3 > 9 4 > 10 4 > 13 5 > > The rest of thae data is irelevent, I don't care which two are returned. > > I am using MySQL on 2k3 server. > > Any help on the SQL here? > > -- > Jay > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187408 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54