MYSQL Statement mit distinct

[bev]

hallo hallo

du hast doch das feld key in tabelle 1 und tabelle 2...

versuch mal ein alias zu vergeben
zb

select distinct t1.key as key1, t2.key as key2, t1.name as name, from Table1 as t1, Table2 as t2 where t1.KEY=t2.KEY and t1.land like '%Österreich%' and t2.kat like '%5%'


gruß

bev