i'm still learning SQL and i can't find if there's a better way to do this. i have two tables
what i want to do is select stuff from the batting table, but i need to get the player's first and last names from the master table, using the playerID i got from the first table. right now i'm just using 2 select stmts, but i think there should be a better way to do this??Code:Batting playerID G H AB .... "abcde01" 10 3 32 Master playerID .... nameFirst nameLast "abcde01" .. "abc" "defgh"
in other words instead of printing
abcde01 10 3 32
i want to say
defgh, abc 10 3 32
without having to do 2 selects
thx
Bookmarks