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
>
begin:vcard
fn:Grzegorz Furmanek
n:Furmanek;Grzegorz
adr;dom:;;16020 N. 77th Street;Scottsdale;AZ;85260
email;internet:
greg@ttiltd.com
tel;work:1 480 443 1077
x-mozilla-html:FALSE
version:2.1
end:vcard
(text/plain)