Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribed

2nd Table:

image text in transcribed

Desired query results:

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Students also viewed these Databases questions

Question

Do not recruit a variety of viewpoints.

Answered: 1 week ago