[sully02]

OK, so if I understand this right, I'd use a query like this:

SELECT *
FROM lmd_draftpicks AS draftpicks
LEFT JOIN lmd_teams AS teams ON (teams.teamid = draftpicks.teamid)
WHERE draftpicks.pickid = $selecteddraft
LEFT JOIN lmd_players AS players on (players.playerid = draftpicks.playerid)
WHERE draftpicks.playerid = $selected draft

Notes:
1 - I want to select all values from the draftpicks table
2 - The tables aren't the same prefix as my vBulletin tables, thus I don't plan to use the TABLE_PREFIX option
3 - Eventually I will be adding another table that has a list of prospects, so I'd need to use LEFT JOIN for 2 separate tables
4 - I will use the teamid field to look up the teamname field and put that in on my template
5 - I will use the playerid field to look up the playername and school fields to put those on my template

Did I do this right?