Ask a Question
Home
Take a Tour
Study Tips
Help Pages
Contact Us
Gallery
Recently Added
Videos
Search
Blogs
Science Blog
Fantastic Facts Blog
Academic Blog
Dictionary
Add New Word
Random Term
Recent Changes
Resource Library
Share Your Resources
Recently Added
Search
Forum
Ask a Question
Log In
Log In
Forgot your password?
Sign Up
for all your
science
needs
Forum
Search
Advanced Search
Image Gallery
Resource Library
Topics
Unresolved Questions
Discussions
Trending
Recent Posts
Chat
Subjects
Join over
250,000
students, educators, and subject enthusiasts in our free online study community
More
Q & A Board
Entire Website
Gallery
Resource Library
Dictionary
Blogs
Search through 1.7M homework questions
Unresolved Questions
•
Discussions
•
Recent
Top Posters
Since Sunday
26
15
11
10
9
9
9
8
8
7
7
7
Post a New Question
Current Questions
Home
Q & A Board
Science-Related Homework Help
Computer Studies
Print
New Topic
Briefly describe subqueries and joins. Explain when each is not an acceptable alternative for the other.
Lola617
Lola617
wrote...
Go to Answer
Posts:
265
Rep:
0
0
A week ago
A week ago
Briefly describe subqueries and joins. Explain when each is not an acceptable alternative for the other.
Briefly describe subqueries and joins. Explain when each is not an acceptable alternative for the other.
Source
Download Study Guide
Database Processing: Fundamentals, Design, and Implementation
Edition:
15
th
Authors:
Kroenke, Auer, Yoder, Vandenberg
Search Textbook Q's
5
/ 5
Briefly describe subqueries and joins. Explain when each is not an acceptable alternative for the other.
5
out of
5
based on
1
votes
Read 17 times
1
Reply
Report
Replies
Answer verified by a
subject expert
makeshsvm
makeshsvm
wrote...
#1
Answer Link
Posts:
190
Rep:
156
0
A week ago
A week ago
Sign in
or
Sign up
in seconds to unlock everything on Biology Forums.
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.
1
1 Vote
mpkelly36
Report
Related Topics
Solved
Briefly describe the representativeness heuristic and explain how it is related
Solved
Briefly describe the representativeness heuristic and explain how it is related
Solved
Compare and contrast subqueries and joins.
Solved
Subqueries cannot be used in combinations with joins (True or false?)
Solved
Explain the different processing methods used by correlated and uncorrelated subqueries.
Solved
While many subqueries can be alternatively written as joins, correlated subqueries do work that ...
Solved
Regarding the interchangeability of subqueries and joins, ________.
Solved
Writing SQL subqueries and joins against normalized tables is simple compared to the code that must ...
Load More
New Topic
Quick Reply
[center][color=gray]Please [b]login or register[/b] to leave a reply[/color][/center]
Explore
Post your homework questions and get free online help from our incredible volunteers.
Why Sign Up?
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
70 People Browsing
123 Signed Up Today
Start New Topic
Take the Tour
Study Tips
Browse by Textbook
New
Related Images
2032
216
100
Your Opinion
Who's your favorite biologist?
Charles Darwin
Carl Linnaeus
Gregor Mendel
James Watson
Rachel Carson
Craig Ventor
Other
Votes: 14
Previous poll results:
Which 'study break' activity do you find most distracting?
Latest Blogs
Animal longevity correlated to these genes
Top 5 Interesting Math Facts You Never Knew
A case for why teenagers make risky decisions
Eyeless fish
Key energy-producing proteins missing in this plant
Ready to ask a question on
Biology Forums
?
Try it out
▸
Explain how to create a relationship in Microsoft Access. Include an example.
–
Computer Studies
Bio discussion
–
General Biology
Which of the following does a Statement of work (SOW) typically not contain?
–
Computer Studies
The IDEF1X default cardinality of a nonidentifying connection relationship is indicated by a dashed ...
–
Computer Studies
In a UML representation of HAS-A relationship, a N:M relationship is expressed as ________.
–
Computer Studies
In IDEF1X, a non-specific relationship is indicated by ________.
–
Computer Studies
In Microsoft Visio 2016, Relationship connector objects can be formatted with the line end symbols ...
–
Computer Studies
A business process is a set of activities that transforms materials into products.
–
Computer Studies
How does Michael Porter define support business activities? What do they include?
–
Computer Studies
Which of the following is not included in Michael Porter's list of support activities?
–
Computer Studies
Loading...