Subject: | |
From: | |
Reply To: | |
Date: | Fri, 9 May 2008 13:57:10 -0500 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Hi all,
I can't seem to get my SQL select to properly do the
distinct parm. No doubt I'm doing something wrong, so help is
appreciated. The query executes, but I don't get distinct p_numbers.
SELECT DISTINCT P_NUMBER,* FROM OPINION WHERE
SUBSTRING(DATES_1,5,1)='A' ORDER BY P_NUMBER;
TIA, and have a great weekend!
<http://www.republictitle.com/>
<http://www.republictitle.com/>
Raymond Shahan
Information Systems
REPUBLIC TITLE OF TEXAS, INC. <http://www.republictitle.com/>
2701 W Plano Parkway
<http://maps.yahoo.com/maps_result?addr=2701+w+plano+parkway&csz=75075&c
ountry=us&new=1&name=&qty=>
Plano, TX 75075
direct 214.556.0202
main 972.578.8611
fax 972.424.5621
www.republictitle.com <http://www.republictitle.com/>
[log in to unmask]
Life is not a journey to the grave with the
intention of arriving safely in a pretty and
well preserved body, but rather to skid in
broadside, thoroughly used up, totally worn out,
and loudly proclaiming:
-- WOW!!! What a Ride!!!
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|