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

When you have to use a default "rollback to" savepoint of plvlog?

810

What is sqlca in db2?

607

what are the advantages of using stored procedures? : Sql dba

704

How do I know if I have sql express or standard?

686

When are we going to use truncate and delete?

627

What are field types?

626

How do you update f as m and m as f from the below table testtable?

1285

What is the difference between a query and a report?

585

Explain the the delete statements in sql?

666

What is cross join sql?

590

How is sql used in oracle?

668

Can you call pl/sql package functions from within a fast formula?

669

Is and as keyword in pl sql?

602

What are the constraints available in sql?

683

Is sql procedural language?

649