2 Ways to Perform Inner Joins
These 2 queries return the same data. They would return all players that are Chicago Bulls players.
SELECT PLAYER,TEAM
FROM dbo.PLAYERS
INNER JOIN dbo.TEAM on PLAYER.TEAMID = TEAM.ID
WHERE TEAM.TEAM = "CHICAGO BULLS"
SELECT PLAYER,TEAM
FROM dbo.PLAYERS
, dbo.TEAM
WHERE PLAYER.TEAMID = TEAM.ID
AND TEAM.TEAM = "CHICAGO BULLS"

0 Comments:
Post a Comment
<< Home