select distinct type from table where category = 'large' ----- Original Message ----- From: "Chad Gray" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 05, 2002 10:19 AM Subject: SQL question
> I have a table that i would like to pull some information out of. It looks > like this > > ID Type Category Name > 1 a large Foo > 2 a large Foo2 > 3 a large Foo3 > 4 b large Foo4 > 5 b large Foo5 > > What i want to do is grab all the 'large' Category. > > Then i want to display what Type related to all the 'large' Category. > > SELECT * > FROM table > WHERE Category = 'large' > > When i return the results i get > > Type > a > a > a > b > b > > What i want to return is: > > Type > a > b > > > Is there a way to return only a and b and not ALL the a's and b's? > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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