compare data in two tables

[malini]

I have two tables
emp - ( has two field)
Name Sal
Joe 45
Jack 50
Kate 67

Dept
Name Dept Sal
Joe IS 46
Jack IS 50
Kate IS 89


I need to write a query which gives in output the records whose column " sal " does not match
the other condition is that i can ignore the ones who Sal has a difference of just 1
in this case Joe has a difference of 1 so i shoudl not print that out.

Help me out in this

Thanks

[MMcCarthy]

I have two tables
emp - ( has two field)
Name Sal
Joe 45
Jack 50
Kate 67

Dept
Name Dept Sal
Joe IS 46
Jack IS 50
Kate IS 89


I need to write a query which gives in output the records whose column " sal " does not match
the other condition is that i can ignore the ones who Sal has a difference of just 1
in this case Joe has a difference of 1 so i shoudl not print that out.

Help me out in this

Thanks

This will only work if the Names are exactly the same.

SELECT emp.Name, emp.Sal, Dept.Name, Dept.[Dept], Dept.Sal
FROM emp INNER JOIN Dept
ON emp.Name = Dept.Name
WHERE emp.Sal - Dept.Sal >1
OR Dept.Sal - emp.Sal > 1

Mary

[isitreel]

Looking to do something similar to this but the tables are in Different DB's?? I have the query working in Test like yours but can't figure out how to make it work across DB's?

I need to validate that Table 1/DB1 Feeder Number Exist in Table 2/DB2. If the valus is NOT in Table2/DB2 update flag to N in Table1/DB1

I am doing this using PL/SQL developer as tool....

Table 1 has 12 colums
table 2 has 25 colums