You can use 'distinct'
in your select statement:

select distinct stuff.firstName, stuffLastName
from stuff

will give you combination of unique first and last name.

Grzegorz V. Furmanek
greg(at)ttiltd.com
http://www.furmanek.net





I.T. Damager wrote:

> I have a query something like this:
>
> select * from stuff
>
> I want to select rows where each name is distinct like:
>
> select distinct name from stuff
>
> The first query gives me all columns, but includes the duplicate 
> names. The second query gives me the name column with no duplicates. 
> How can I combine the two, so I get all columns, but without duplicate 
> names?
>
> Thanks
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change  you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>