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

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

745

how to present a past time in hours, minutes and seconds? : Sql dba

551

What are the events on which a database trigger can be based?

586

Is join and inner join the same?

533

How many aggregate functions are available there in sql?

523

what is the stuff function and how does it differ from the replace function? : Sql dba

615

Is the primary key an index?

591

does sql support programming? : Sql dba

603

How to display the records between two range in Oracle SQL Plus?

636

What are the sql versions?

514

What is the maximum number of rows in sql table?

538

how would concatenate strings in mysql? : Sql dba

564

What is data definition language?

616

Is primary key clustered index?

516

What are all the different normalization?

556