Top Posters
Since Sunday
22
21
20
17
16
15
15
14
14
14
14
14
New Topic  
wrote...
Posts: 261
Rep: 0 0
2 months ago
Briefly describe subqueries and joins. Explain when each is not an acceptable alternative for the other.
Source  Download
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 28 times
1 Reply
Replies
Answer verified by a subject expert
wrote...
Posts: 189
2 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
  354 People Browsing
 113 Signed Up Today
Your Opinion
Where do you get your textbooks?
Votes: 94

Previous poll results: Do you believe in global warming?
Related Images
 1103
 106
 223