Select distinct type from table where Category = 'large'
At 12:43 PM 1/5/2002 -0800, you wrote: >Try using RecordCount...Something like if the RecordCount of the type > >1 then don't print or something.... > >I am not sure exactly how to do it...Dave Watts should know.... > >Julia Green >Julia Computer Consulting >PO Box 279 >Watertown MA 02471 >[EMAIL PROTECTED] >http://www.juliagreen.com > > >--- Chad Gray <[EMAIL PROTECTED]> wrote: > > 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? > > > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
