Question

MySQL problem. Show MySQL queries to solve these problems.

DO NOT USE JOIN keyword to solve this

Question 1: Rows in A, but not in B

Question 2: Rows in B, but not in A

Question 3: Rows in A and B, no overlap

Question 4: Rows in A and B (Full Join)

REMINDER: DO NOT USE JOIN KEYWORD

Answer 1

1)Rows in A but not in B:- (A-B)

SQL MINUS operator can be used to retrieve all rows in the first data set which are not returned by the second dataset. This operator is supported by all sql databases.

Select * from A [where condition]
MINUS
SELECT * from B [where condition];

Note: You can also use EXCEPT instead, but this is not supported by all sql databases.

2)Rows in B but not in A:- (B-A)
Select * from B [where condition]
MINUS
Select * from A [where condition];

3) Rows in A and B, no overlap:- (Symmetric Difference)
Select * from A UNION Select * from B
EXCEPT
Select * from A INTERSECT Select * from B;

4)Rows in A and B:-(AUB)
The SQL UNION operator can be used to combine the rows of two or more datasets
with no duplicate rows.

Select * from A
UNION
Select * from B;

Note: UNION ALL can be used if you want to display duplicate rows