Re: SELECT only unique records

[Dwight Trumbower]

At 01:02 PM 9/12/2003, Comcast wrote:

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'
SELECT DISTINCT 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]