columns, you can't do it in a single pass. You'll have to either used a
stored procedure to do it in 2 steps, or use a SubQuery (which I guess
is a "single pass" but I still kind of consider it a hacked-up way of
doing 2 steps).
-----Original Message-----
From: Bosky, Dave [mailto:[EMAIL PROTECTED]
Sent: Friday, August 20, 2004 15:29
To: SQL
Subject: RE: return only one row for each id field that meets the
criteria .
Yeah. I tried DISTINCT and it didn't work nor did the GROUP BY.
It seems like there should be a simple solution but....maybe I'll
looking at
it too much :-)
Thanks. Any additional suggestions are welcome.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
