To get data from more than one table, you need to relate the tables by applying join clauses in your query.
This book shows you how to use the various types of join provided by INNER; Conditional; Self Join; LEFT, RIGHT and FULL OUTER; NATURAL; Cross product; SEMI and ANTI; Positional; and, ASOF.