Sign in to follow this  
Followers 0
melnib00ne

SQL LEFT OR RIGHT JOIN ?

2 posts in this topic

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

0

Share this post


Link to post
Share on other sites

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'";

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.