Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Post
by answerhappygod »
- 7 You Are Given The Following Two Tables T1 And T2 Use The Tables To Provide Your Answers You Need To Submit The Sql 1 (83.3 KiB) Viewed 24 times
7. You are given the following two tables T1 and T2. Use the tables to provide your answers. You need to submit the SQL for (b) and (c). T1 T2 Guest Name Guest 1 Guest 2 GuestName Guest 1 Guest 3 Guest 4 Guest 6 Guest 7 Guest 3 Guest 4 GU st Guest 6 Guest 8 Guest U1 Guest 7 Guest 8 Guest U2 (a) Explain the differences between an inner join and an outer join. (b) Write the SQL with an inner join to find the guests in T2 who are also in T1. (c) Write the SQL with an outer join to count the number of guests in T2 who are not in T1.
CUSTOMER INVOICE LINE PK INV NUMBER 主 contains TAPK PK,FK1 INV NUMBER LINE NUMBER PK CUS CODE HE generates CUS_LNAME CUS_FNAME CUS_INITIAL CUS AREACODE CUS_PHONE CUS_BALANCE FK1 CUS_CODE INV_DATE FK2 P_CODE LINE_UNITS LINE_PRICE is found in PRODUCT VENDOR PK V_CODE PK P CODE V_NAME V_CONTACT HE .- supplies V_AREACODE V_PHONE V_STATE V_ORDER P_DESCRIPT P_INDATE P_QOH P_MIN P_PRICE P_DISCOUNT FK1 V_CODE Cengage Learning © 2015
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!