select b.empno as empno, b.ename as ename from a, b where a.empno!=b.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 / rajesh venati

Answer Posted / rajesh venati

select b.empno as empno, b.ename as ename from a, b where
a.empno!=b.empno;

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is delimiter in pl sql?

1100

What is query syntax?

1020

What is a sql trace file?

1085

What is right join in sql?

1157

When should I use nosql database?

1056

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

1019

How do you bind variables in pl sql?

1160

Can you inner join the same table?

1039

What is $$ in sql?

1045

Explain the the update statement in sql?

1104

What are the disadvantages of file system?

1359

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1186

What are predefined functions in sql?

1107

Inline the values in PL/SQL, what does it mean.?

1275

What are the limitations of sql express?

1117