Posted by Ed Murphy on 01/19/07 13:45

jim wrote:

> I've been searching and trying out SQL statements for hours and I'm
> still having a problem.
>
> I'm querying 3 tables... and I only want the first unique record
> returned.

You need to clearly define "unique" and "first". Based on your
example, it looks like you mean "unique combination of values from
the first two columns" and "lowest value from the third column".

> Currently, the data returned looks like this..............
>
> New York New York A
> New York New York B
> New York New York C
> Los Angeles California A
> Los Angeles California B
> Los Angeles California C
>
>
> I want the select statement to return this instead...
>
> New York New York A
> Los Angeles California A

select c1, c2, min(c3)
from t1
group by c1, c2

You'll need to adjust this to account for three tables instead of
one, but hopefully you get the idea.

[Back to original message]