select ZlEmployee.Code,   
        ZlEmployee.Name,
         ZlEmployee.zhiwu,
        ZlEmployee.zhiji,
         ZlEmployee.dept,
         jc_,
         jc_canci.ccode,
         ZlEmployee.id,
         jc_register.jctype,
         '' ad_status,
         '' ad_collect,
         '' ad_pdate,
         '' ad_cheked
from ZlEmployee,jc_register,jc_canci
where (ZlEmployee.ID = jc_register.empid) and
       (ZlEmployee.ID not in (select jc_order.empid from jc_order where ZlEmployee.ID = jc_order.empid and  convert(char(10),jc_order.pdate,120) = :ad_date )) and
        (ZlEmployee.ID not in (select jc_original.empid from jc_original where ZlEmployee.ID = jc_original.empid and convert(char(10),jc_original.pdate,120) = :ad_date and (jc_original.canciid = jc_canci.id)))  

这是数据窗口的SQL语句
我想用建视图方法，功能同上一样。不知该如何建呢。帮帮忙。先谢过。急。。。