>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.

SELECT
  empcode
, empname
, somename = CASE WHEN EmpMaster.empsts> 0 THEN empmaster.Remark ELSE Details.Remark END
 FROM  EmpMaster JOIN Details ON EmpMaster.empcode = Details.empcode

>
>Regards
>Abdulla