select b.empno as empno, b.ename as ename from a, b where a.empno!=b.empno

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 / rajesh venati

Answer Posted / rajesh venati

select b.empno as empno, b.ename as ename from a, b where
a.empno!=b.empno;

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is PL/SQL Records?

1116

Does postgresql run on the cloud?

1080

What are the benefits of pl/sql packages?

1034

how can we submit a form without a submit button? : Sql dba

918

Why use truncate instead of delete?

962

What are the two types of periodical indexes?

887

Why having clause is used in sql?

931

What are the types of functions in sql?

968

Why do we use set serveroutput on?

926

What is the difference between mdf and ndf files?

1063

what are all the different types of indexes? : Sql dba

998

Does pdo prevent sql injection?

886

What is union?

1085

Does sql use python?

978

how to enter numeric values as hex numbers? : Sql dba

1008