If our task is to retrive pieces of information stored in different tables using single query statement, we will use join between two or more tables. Let's see example where we want to retrive Departemnt name in addition to the information stored in Employees table. At first we pick up two tables, give them aliases and chose certain fields from each table. After this we specify Join condition in WHERE clause, that in our case will be based on the value of DeptNo column.