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

Can we insert data into materialized view?

499

How is pl sql different from sql?

537

What is %type in pl sql?

536

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2567

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

529

What is linq to sql?

547

Which join is default?

515

How many types of triggers exist in pl/sql?

561

Can we delete column in sql?

557

What is scope and visibility in PL/SQL?

592

how can we know the number of days between two given dates using mysql? : Sql dba

539

how to check server status with 'mysqladmin'? : Sql dba

562

Do we need to create index on primary key?

461

Is sql free?

497

What is the difference between row level and statement level trigger?

510