Andrew - the query you posted using UNION SOLUTION works when you only select one field per table, however, if you add more fields (as I need to), the output looks like a Cartesian. Any other ideas? Thanks!
----- Original Message ----- From: "Cantrell, Adam" <[EMAIL PROTECTED]> Hehe, I was going to post the same thing, but I caught myself. That will only return two records - not two records per each unique columnXYZ. Off the top of my head, I can't think of a correct answer - it will come to me, or someone else will post it before I figure it out. Adam. > -----Original Message----- > From: Matthew R. Small [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 05, 2002 2:53 PM > To: CF-Talk > Subject: RE: Query help > > > select top 2 * from table > where number in > (select distinct number from table) > > - Matt Small ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists