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 the difference between sql and isql*plus?

1073

What is left inner join in sql?

1023

Why do we go for stored procedures?

1034

Explain raise_application_error.

1078

What is primary key in db?

992

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1046

What is a pdo connection?

1008

What are all the ddl commands?

1170

What is the use of triggers?

1022

What packages are available to pl/sql developers?

1031

what is a field in a database ? : Sql dba

1043

What is the importance of sqlcode and sqlerrm?

1330

Is sql open source?

954

What is sql catalog?

1000

Define a temp table?

1005