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

10 Answers
13618 Views
Satyam, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is integrity in sql?

1051

What are the steps for performance tuning.

1340

How to use distinct and count in sql query? Explain

1027

Name three sql operations that perform a sort.

1018

Does execute immediate commit?

1223

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

4020

Is sql a scripting language?

1021

When can we use the where clause and the having clause?

1021

How do you get column names only for a table (sql server)?

1170

What is a sql*loader control file?

1272

What is set transaction?

1040

What is union, minus and interact commands?

1300

What is the sql*loader? : aql loader

1057

Is sqlite free?

977

how many columns can be used for creating index? : Sql dba

947