RE: SELECT only unique records

2003-09-15 Thread Petre Agenbag
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

Re: SELECT only unique records

2003-09-15 Thread Bruce Feist
Petre Agenbag wrote: How can one select unique rows based on a set of fields select distinct state_ID from financial_master where category_id='1' only returns rows based on the uniqueness of one field. what if there is another field that COMBINED with state_ID forms a unique row; how can one

SELECT only unique records

2003-09-12 Thread Comcast
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'

RE: SELECT only unique records

2003-09-12 Thread Dan Greene
] 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

RE: SELECT only unique records

2003-09-12 Thread Fortuno, Adam
: 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

RE: SELECT only unique records

2003-09-12 Thread Roger Davis
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

RE: SELECT only unique records

2003-09-12 Thread Dathan Vance Pattishall
---Original Message- --From: Comcast [mailto:[EMAIL PROTECTED] --Sent: Friday, September 12, 2003 11:03 AM --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

Re: SELECT only unique records

2003-09-12 Thread 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

RE: SELECT only unique records

2003-09-12 Thread Paul DuBois
will not. DISTINCTROW is a synonym for DISTINCT. 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