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

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a subquery in sql?

975

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1019

How is sql used in oracle?

968

what is a database lock ? : Sql dba

1092

what is column? : Sql dba

959

What is the example of procedure?

874

What is difference between stored procedure and trigger?

1057

Explain scalar functions in sql?

1016

Is join same as left join?

977

Does group by remove duplicates?

978

What is oracle sql developer?

991

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7134

what are different types of keys in sql?

1064

What are tables in sql?

996

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2069