Use the DISTINCT keyword.
SELECT DISTINCT table2.* FROM table2, table1 WHERE table2.id=table1.id
-Original Message-
From: Tarik Ansari [mailto:[EMAIL PROTECTED]]
Sent: 22 November 2002 17:10
To: [EMAIL PROTECTED]
Subject: Selecting rows issue
Hello,
I got two tables containing foll
Hello Tarik,
The DISTINCT option will sort this out for you.
=dn
> I got two tables containing following data :
>
> table1
> --
> id
> --
> 2
> 3
> 2
> 2
>
> table2
> --
> id | label
> --
> 1 | one
> 2 | two
> 3 | three
> 4 | four
>
> I would like to select table2's rows th
