adding new column to sql and check status
Posted on 2013-02-04
I have two tables : employee and customer
employee table has
customer table has
My requirment is :
I have to check if salary of employee table matchees with salary of customer table for a given id, If they dont match create a new column 'Status' with value false. If it matches then its True.
Right now i have
select id, salary from employee
where employee.id = ?
select id, salary from customer
where customer.id = ?
How can i come up with the extra column to compare salary of employee with salary of customer for a given id.
Any help will be greatly appreciated