Question: 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 Plug4
Step by Step Solution
There are 3 Steps involved in it
SQL Query to Combine Two Tables into One Result Set Without Modifying or Inserting Problem Context Y... View full answer
Get step-by-step solutions from verified subject matter experts
