SELECTing from multiple tables.

Dev Shed Forums Sponsor:

January 10th, 2012, 04:09 PM

bill.brannan

Registered User

Join Date: Jan 2012

Posts: 1

Time spent in forums: 20 m 42 sec
Reputation Power: 0

SELECTing from multiple tables.

This may be pretty simple but I just can't figure it out.

Lets say I have 3 tables - team, player, position

team.id
team.name

player.team_id
player.first
player.last
player.position_id

position.id
position.name

So team and player are related via id->team_id and player and position are related via id->position_id

player.position_id is the only column allowed to be NULL so I may have players that have a team but not a position.

That being said, how do I get the following results for all players?

team.name | player.first | player.last | position.name

January 11th, 2012, 03:05 AM

swampBoogie

Contributing User

Join Date: Jan 2003

Location: Paris Uppland

Posts: 2,279

Time spent in forums: 1 Month 1 Day 22 h 49 m 59 sec
Reputation Power: 388

Code:

select team.name,
       player.first,
       player.last,
       position.name
  from team
  join player
    on team.id = player.team_id
  left
  join position
    on player.position_id = position.id

Viewing: Dev Shed Forums > Databases > PostgreSQL Help > SELECTing from multiple tables.

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump