select *from B where (empno,ename) not in (Select empno,ename 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 / arun

Answer Posted / arun

select *from B where (empno,ename) not in (Select
empno,ename from A)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is 'mysqlcheck'? : Sql dba

994

What is a clob in sql?

1002

If a cursor is open, how can we find in a pl/sql block?

1149

how to calculate expressions with sql statements? : Sql dba

1023

what is oltp (online transaction processing)? : Sql dba

1066

What is sql*loader and what is it used for?

1121

What is lookup table in sql?

1019

what is innodb? : Sql dba

1085

What is the source code of a program?

1047

How to revise and re-run the last sql command?

1146

What is the difference between nvl function, ifnull function, and isnull function?

1087

How many scalar data types are supported in pl/sql?

1028

what is the syntax used for partition in tsql? : Transact sql

997

What is error ora-01000: maximum open cursors exceeded

1126

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1095