Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need a SQL query to combine 2 tables into 1 query result but still having separate rows from each table. WITHOUT using INSERT or
I need a SQL query to combine 2 tables into 1 query result but still having separate rows from each table.
WITHOUT using INSERT or modifying either of the tables
First Table:
2nd Table:
Desired query results:
As you can see, the quantity columns are combined into 1 and all the rows from each table are still separately listed. Please provide me the SQL query to accomplish this. Again, NOT using INSERT or modifying either of the tables. NOT creating a new table either.
Inv Table 1 Inv 1 Quantity 51 Location Item ID Plug1 Plug2 Plug3 Plu 10 72 13 19 24 Inv Table 2 39 79 83 82 2 Plugi Plug2 Plug3 Plug4 4 Item ld Location Quantity Plugl Plug2 Plug3 Plug4 Plug1 39 79 83 82 51 72 25 24 2 4 10 11 13 19 Plug3 Plug4Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started