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

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

1162

Who is the owner of mysql database?

1106

what are properties of a transaction? : Sql dba

1134

What is form and report?

1052

What are sql procedures?

1084

What does over partition by mean in sql?

1040

What is data manipulation language?

1232

What is rownum in sql?

1092

What is oracle sql called?

973

What normalization means?

1014

Which data dictionary views have the information on the triggers that are available in the database?

1298

What is an escape character in sql?

1071

how to shutdown mysql server? : Sql dba

1145

what is a database transaction? : Sql dba

1256

What is the difference between stored procedure and view?

1064