[pc.net]

distinct eliminiert doppelte einträge ...

select distinct t1.spalte1,
                t1.spalte2,
                t2.spalte2
from tabelle1 t1,
     tabelle2 t2
where t1.spalte1 = t2.spalte1
order by t1.spalte1