>Mr. Cetin,
>
>Yes, i agreed with you that Job Nos. and times are changing,
>But if i make query based on Date, Or (Date and Job No.) Or (Date And Employee And Job)
>
>(ie, the Table structure and data like as follows)
>
>Date EmpCode JobNo. Time
>01/04/2005 A Job1 3
>01/04/2005 A Job2 3
>01/04/2005 A Job3 2
>01/04/2005 B Job1 8
>
>How will be the Sql Satemant.
>
>Rgards
ldDate = {^2005/04/01}
lcJob = 'Job1'
lcEmpCode = 'A'
text to m.lcSQL noshow
select Date,EmpCode, JobNo, Time
from mySQLServerTable
where Date = ?m.ldDate
and JobNo = ?m.lcJob
and EmpCode = ?m.lcEmpCode
endtext
SQLExec(m.lnConHandle,m.lcSQL,'myResult')
Cetin