select * from b where b.empno not in(select a.empno from a);

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 / damy

Answer Posted / damy

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is full form of rtm?

1009

Why do we use procedures in pl sql?

1045

Why do we create views in sql?

1155

What found sql?

947

Are views faster than queries?

994

How does a covering index work?

969

What are the parts of a sql statement?

1090

What is pl sql package?

1038

What is cursor in pl sql with examples?

1035

Is sql the best database?

979

What are stored procedures used for?

1003

What does desc stand for?

1075

What is query optimization in sql?

987

How do I count rows in sql query?

996

What is java sql driver?

1129