melnib00ne

Hi, i have a php-page with an mysql-connection and have a problem with left and right join query. i have two tables with two selectboxes on the page. table1 (laenderliste): id,kontinent,land,hauptstadt,iso2,iso3,ioc,domain,waehrung,vorwahl 1 Asien Deutschland Berlin DE DEU GER .de EUR 49 2 Asien Afghanistan Kabul AF AFG AFG .af AFN 93 3 Nordamerika Aruba Oranjestad AW ABW ARU .aw ANG 297 table2 (regionen): id,vid,iso2 1 1 0 DE 2 2 0 DE 3 2 0 AF 4 2 1 DE 5 2 1 AF 6 3 0 DE 7 4 0 DE 8 2 2 DE 9 2 2 AF 10 5 0 DE now, i would have all countrys (land on table1) who's not in table2. the field iso2 where the key to compare the two tables. sql-query: $sql = "SELECT l.iso2, l.land FROM laenderliste l LEFT JOIN regionen r ON l.iso2 = r.iso2 WHERE r.vid <> '$vid'"; whats wrong in my sql-query ? can someone help me please ? thanks