What techniques are used to retrieve data from more than one table in a single SQL statement? Joins, unions and nested selects are used to retrieve data.