SQL LEFT OR RIGHT JOIN ?

[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

[geezery]

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

$sql = "SELECT a.iso2,a.land FROM laenderliste a, regionen b WHERE a.iso2 = b.iso2 AND b.vid <> '$vid'";