What techniques are used to retrieve data from more than one table in single SQL STATEMENT?

• A. union
• B. Joins
• C. all the above
• D. nested selects