select e2.empno, e2.ename from A e1, B e2 where e1.empno!=e2.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 / sayalibsl

Answer Posted / sayalibsl

select e2.empno, e2.ename from A e1, B e2
where e1.empno!=e2.empno;

Is This Answer Correct ?

15 Yes

5 No

Please Help Members By Posting Answers For Below Questions

what is data manipulation language? : Sql dba

525

what is a cursor? : Sql dba

549

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2088

What is trigger types of trigger?

548

What is the file extension for sql database?

513

Which nosql database is best?

509

What is benefit of creating memory optimized table?

535

Explain the types of joins in sql?

569

Is join and inner join the same?

533

Why is sql important?

575

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3101

What is materialized view. What are different methods of refresh?

775

What is delete command in sql?

549

Why do we need pl sql?

546

What is varchar used for?

527