Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account



Photo

SQL LEFT OR RIGHT JOIN ?

- - - - -

  • Please log in to reply
1 reply to this topic

#1
melnib00ne

melnib00ne

    Newbie

  • Member
  • 16 posts
  • Joined 12-November 04
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


How to remove advertisement from MSFN

#2
geezery

geezery

    Member

  • Member
  • PipPip
  • 254 posts
  • Joined 21-July 06

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 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users