Hi Experts,

I have two tables

(1) EMPMST

EmpCode
EmpName

(2) EMPATT

EmpCode
EmpDate
EmpAtt
EmpRate

cSql = "Select EmpMst.EmpName As Name,EmpAtt.EmpDate As Date,EmpAtt.EmpAtt As AttHrs,EmpAtt.EmpRate As ;
Rate From BetaSql.dbo.EmpMst,BetaSql.dbo.EmpAtt where Len(EmpMst.EmpCode) > 0 and EmpMst.Empcode = ?;
cEmpCode And EmpMst.EmpCode = EmpAtt.EmpCode"

I m Trying to retrive some date using SQLEXEC(Connectionhandle, cSql,'Abc') function, But when i
save this statement, it gives some error in side the quots that 'command contains unrecognized phrase/keyword '. Then i removed alias referances and after that not showing any errors, But how will
put conditions like 'EmpMst.EmpCode = EmpAtt.EmpCode' ?. Thanks in advance

Regards
Abdulla