hi experts,

i have two files EmpMaster and Details
i want make a query based on the value of EmpMaster-> empsts field
if it is >0 select value from Empmastre, else i want to select data from detail file.
,ie

'Select empcode,empname,iif(empsts >0,empmaster.Remark,(i want to select remark from Details
files base on EmpMaster.empcode = Details.empcode))'

plse help me how to do it in sql server.

Regards
Abdulla