MYSQL Statement mit distinct

[weev]

ups. das war ja falsch *g*

Syntax:
select distinct t1.KEY as KEY, t1.name as name, t1.land as land, t1.gebiet as gebiet from table1 as t1, table2 as t2 where t1.KEY=t2.KEY and t1.land like '%Österriech%' and and t2.kat like '%5%'

-weev