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
