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

How do I create a memory optimized filegroup?

946

What is sql server and ase?

1007

What is informix sql?

963

What is the left table in sql?

952

What are the methods of filing?

919

What is denormalization in a database?

1030

Is nosql relational?

927

What is sql prepared statement?

966

What is difference between inner join and cross join?

953

How do I send sql query results to excel?

1048

What is the most important ddl statements in sql are?

981

what is meant by nl2br()? : Sql dba

1011

What is sql trigger example?

1032

What is difference between primary and secondary key?

1009

What is the difference between view and stored procedure?

950