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 sql comments?

1075

How to write pl sql program in mysql command prompt?

1099

How do you go back in sql?

986

How do you change a value in sql?

1019

what is sql in mysql? : Sql dba

1196

Why coalesce is used in sql?

1012

What does 0 mean in sql?

966

How do I run sql profiler?

1072

Can sql function call stored procedure?

1025

What is type and rowtype in pl sql?

1016

How can you load multi line records? : aql loader

1076

how to create a new view in mysql? : Sql dba

938

What are the different operators available in sql?

1000

give the syntax of grant and revoke commands? : Sql dba

1153

Why truncate is used in sql?

1005