mysql query left join or data insert?

mysql query left join or data insert?

OK - I have three tables, structured below
tbl_1
------
userid
teamid
teamname
eliminated
tbl_2
------
teamid
week
team
tbl_3
------
team
NFLname
nfl-schedule
------
week
time
awayteam (same as "team" in tbl_3)
hometeam (same as "team" in tbl_3)
This is a query on a "survivor league" where I need to get the teamid,
teamname, eliminated, team, week, and NFLname for each week. If a user
hasn't selected a team for this week, week 2 for instance, I want to see a
blank row for that week. I"m assuming I could backfill the rows into the
database for each teamid, but was wondering if I could do this simply with
sql and some inner joins?
select a.teamid, a.teamname, a.eliminated, b.team, b.week, c.NFLnamefrom
`tbl_1` a
left join `tbl_2` b on a.teamid = b.teamid
left join `tbl_3` c on c.`team` = b.team
where a.userid = XXX