select * from a full outer join b on a.empno=b.empno minus select *

TABLE A TABLE B
EMPNO ENAME EMPNO ENAME
1 A 1 A
2 B 2 B
3 C 3 C
4 D 4 D
5 E 5 E
6 F
7 G
HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

Question Posted / baji

Answer Posted / baji

select * from a full outer join b on a.empno=b.empno
minus
select * from a inner join b on a. empno=b.empno;

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

explain primary keys and auto increment fields in mysql : sql dba

980

How do I view a sql trace file?

1035

How does postgresql compare to oracle/db2/ms sql server/informix?

1038

Why do we need pl sql?

982

what are enums used for in mysql? : Sql dba

1171

What is right join in sql?

1096

What is rownum and rowid?

1035

Why is normalization important?

1032

What is the meaning of disabling a trigger?

1182

How do I install sql?

1002

tell me about various levels of constraint. : Sql dba

1035

how many values can the set function of mysql take? : Sql dba

992

What is a recursive join sql?

1077

How exception handling is done in advance pl/sql?

983

What is coalesce sql?

1004