How would I go about putting an IF THEN statement in a select query. Example:
SELECT Name, Age, SSN, Pay, PayType
FROM Base, Payroll
WHERE BaseID = PayrollID AND
IF paytype = '0' then bencomp3
ELSE BASE
I am confused as to how I would put that into my select statement. Any help would be appreciated.
Neozero
SELECT Name, Age, SSN, Pay, PayType
FROM Base, Payroll
WHERE BaseID = PayrollID AND
IF paytype = '0' then bencomp3
ELSE BASE
I am confused as to how I would put that into my select statement. Any help would be appreciated.
Neozero