Hi
Create Table Empinfos
(
EmpID int primary key identity(1,1),
DeptId int,
Empamount decimal(18,2),
EmpBonus decimal(18,2)
)
Create Table EmpPays
(
EmpID int
)
--Insert into Empinfos values(1,2000,3000)
--Insert into Empinfos values(2,4000,5000)
--Insert into Empinfos values(3,5000,6000)
--Insert into EmpPays values(1)
--Insert into EmpPays values(2)
Select * from Empinfos inner join EmpPays on Empinfos.EmpID=EmpPays.EmpID
--Empid deptid empamount empbonus empid
1 1 2000.00 3000.00 1
2 2 4000.00 5000.00 2
-- My need is how to check my select query empamount empbonus are equal or not
--for if equal means print 'yes' else ' no' how to solve this select query
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com