Combine two queries in oracle and result the combined query

Question

0.00/5 (No votes)

See more:

I have two queries which results below data from each table

Query 1

Address_ID	Display Value	     Account_ID
1000	        10001 - Test 1	     100
1000	        10002 - Test 2	     200
1000	        10003 - Test 3	     300


Query 2

Address_ID	Display Value	   Account_ID
2000	        10001 - Test 1	   100
3000	        10004 - Test 4	   400


I need to combine these Queries and get the data as below as we see Account ID (100) do exist the same from both queries take row for that Account ID from first Query.

Address_ID	Display Value	 Account_ID
1000	      10001 - Test 1	100
1000	      10002 - Test 2	200
1000	      10003 - Test 3	300
3000	      10004 - Test 4	400


Any help is much appriciated.

What I have tried:

I tried with Union and Minus and Joins as well

Posted 10-Jul-20 8:01am

User CP

Updated 10-Jul-20 8:19am

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 14886390 · Accepted Answer · 2020-07-10T08:19:00

Solution 1

For both SQL Server and Oracle you can use this sort of construction....
Select Address_ID, Display_Value, Account_ID
from FirstTable
union
Select Address_ID, Display_Value, Account_ID
from SecondTable
Where SecondTable.Account_ID not in (select FirstTable.Account_ID from FirstTable);

Posted 10-Jul-20 8:19am

Member 14886390

Combine two queries in oracle and result the combined query

1 solution

Solution 1

Add your solution here

Preview 0

Combine two queries in oracle and result the combined query

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us