Mysql table join 2 tables

Question

i have two tables in mySQL:

Table 1: Club(ClubID=PK, club_name)

Table 2: League_table(tableID=PK, position, clubID=fk, games_played, points)

how would i join the two tables to give a query that displayed only

(position, club-name, games_played)

diegoe · Accepted Answer · 2012-03-22 18:53:53Z

2

Simple join:

select l.position, c.club_name, l.games_played
from club c, league_table l 
where l.clubid=c.clubid

answered Mar 22, 2012 at 18:53

diegoe

2562 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

alexn · Accepted Answer · 2012-03-22 18:51:27Z

1

You are looking for a left join. ClubID is the foreign key (the column "connecting" the two tables).

select position, club_name, games_played
from league_table
left join club on club.ClubId = league_table.clubID

answered Mar 22, 2012 at 18:51

alexn

59.2k14 gold badges114 silver badges146 bronze badges

user1285324 · Accepted Answer · 2012-03-23 06:23:40Z

0

select a.club_name, b.position, b.games_played from club as a join league_table as b on a.clubid=b.clubid Thats what you want.

@Alexen: No need of left join in this case.

@Diegoe: one friendly advise, always use on in join, without it query goes slow down when you are working on big tables.

answered Mar 23, 2012 at 6:23

user1285324