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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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