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:

I need a SQL query to combine 2 tables into 1 query

2nd Table:

result but still having separate rows from each table. WITHOUT using INSERT

Desired query results:

or modifying either of the tables First Table: 2nd Table: Desired query

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

1 Expert Approved Answer
Step: 1 Unlock

SQL Query to Combine Two Tables into One Result Set Without Modifying or Inserting Problem Context Y... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!