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
|