[Job_Nr] = jobnr
and
[Date]=ftgdate
and
not(deleted)