To retrieve data from more than one table we could use
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Can a UNION and a JOIN be used in the same SELECT statement
- Which of the following SQL clauses is used to select data from 2 or more tables?
- Can UNION be used along with outer join.
- The outer and inner queries can get data from different tables?
- A join can be used to combine information from two separate tables
- Consider the query: (select customer-name from depositor) union (select customer-name from borrower) The ou...
- To write a query that performs an outer join of tables A and B and returns all rows from B, you need a:
- There are 10 tables with similar structure but mutually exclusive records. A query needs to fetch some reco...