Join
Microsoft: DAT201x: Querying with Transact-SQL
http://www.youtube.com/watch?v=Ya9DOHlxN_I