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 are the uses of merge?

1225

What is program debugging?

1342

How do you modify a trigger?

981

What is out parameter used for eventhough return statement can also be used in pl/sql?

1123

What is offset in sql query?

1176

What is number function in sql?

1017

How to create a menu in sqlplus or pl/sql?

1166

what is cross join? : Sql dba

1048

how to include character strings in sql statements? : Sql dba

1136

What are some emotional triggers?

1033

How can you select unique records from a table?

1146

What is the execution plan in sql?

1070

Can we use rowid as primary key?

1043

Is id a reserved word in sql?

1187

How do we use distinct statement? What is its use?

1075