Top Posters
Since Sunday
14
14
12
11
11
11
10
10
10
10
9
9
New Topic  
wrote...
Posts: 263
Rep: 0 0
5 months ago
Briefly describe subqueries and joins. Explain when each is not an acceptable alternative for the other.
Textbook 
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 54 times
1 Reply
Replies
Answer verified by a subject expert
wrote...
Posts: 189
5 months ago
Sign in or Sign up in seconds to unlock everything.
Subqueries and joins are both methods for retrieving data from multiple tables. Subqueries involve nesting one SELECT statement within another. The nested SELECT is used as part of a condition in the WHERE clause of the first SELECT statement. The nested SELECT statement can return a set of records from one table, which are then used in a logical operator within the parent SELECT query. A join combines records from each table into concatenated records containing the fields of both tables. The records are concatenated based on matching values in similar columns in the two tables. Subqueries cannot be used in situations where the results to be displayed include attributes from more than one table. Joins cannot be used as an alternative to a correlated subquery.
This verified answer contains over 120 words.
Related Topics
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  89 People Browsing
Your Opinion
Which of the following is the best resource to supplement your studies:
Votes: 51

Related Images
 75
 37