question

naveaelizabeth avatar image
naveaelizabeth asked

Max records for join

Table CUSTOMER_MSTR has 100 records and table CUSTOMER_TXNS has 500 records. What is the maximum number of records you can get in a result set if you did the following types of joins?  INNER JOIN on account_id  LEFT JOIN CUSTOMER_MSTR with CUSTOMER_TXNS on account_id  UNION  UNION ALL
tablejoininner joinleft join
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image David Wimbush commented ·
This is your chance to learn important fundamental stuff about how the SQL language works. Read about how these join types work. Then you'll understand it and will be able to answer the question. Then, if you want, post what you think the answers are and I'm sure somebody will be happy to confirm whether you're right or help you if you've misunderstood something.
2 Likes 2 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Homework?
1 Like 1 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.