SELECT state_ID FROM financial_master WHERE category_ID = '1' becomes SELECT unique state_ID FROM financial_master WHERE category_ID = '1' -or- SELECT distinct state_ID FROM financial_master WHERE category_ID = '1'
2 points ! > -----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' > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]