Try SELECT DISTINCT state_ID FROM financial_master WHERE category_ID = '1'
Roger > -----Original Message----- > From: Comcast [mailto:[EMAIL PROTECTED] > Sent: Friday, September 12, 2003 2:03 PM > To: [EMAIL PROTECTED] > Subject: SELECT only unique records > > > I am sure this is a slam-dunk, but I am new to this and stumped > ... thanks. > I have the following statement, but I need it to pull only unique > listings - I get repeated items. > > SELECT state_ID FROM financial_master WHERE category_ID = '1' > > > > > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
