SELECT PROJ_HRS.* FROM PROJ_HRS WHERE (PROJ_HRS.proj_cat_no = 1 OR PROJ_HRS.proj_cat_no = 3 OR PROJ_HRS.proj_cat_no = 6) AND PROJ_HRS.atelier = 0 AND PROJ_HRS.accepted = 0 AND PROJ_HRS.refused = 0 AND PROJ_HRS.wrk_hrs <> 0MartinJ
>lcSqlStatement = "SELECT PROJ_HRS.* " +; > "FROM PROJ_HRS " +; > "WHERE PROJ_HRS.proj_cat_no = 1 " +; > " AND PROJ_HRS.atelier = 0 " +; > " AND PROJ_HRS.accepted = 0 " +; > " AND PROJ_HRS.refused = 0 " +; > " AND PROJ_HRS.wrk_hrs <> 0 " +; > "UNION ALL SELECT PROJ_HRS.* " +; > "FROM PROJ_HRS " +; > "WHERE PROJ_HRS.proj_cat_no = 3 " +; > " AND PROJ_HRS.atelier = 0 " +; > " AND PROJ_HRS.accepted = 0 " +; > " AND PROJ_HRS.refused = 0 " +; > " AND PROJ_HRS.wrk_hrs <> 0 " +; > "UNION ALL SELECT PROJ_HRS.* " +; > "FROM PROJ_HRS " +; > "WHERE PROJ_HRS.proj_cat_no = 6 " +; > " AND PROJ_HRS.atelier = 0 " +; > " AND PROJ_HRS.accepted = 0 " +; > " AND PROJ_HRS.refused = 0 " +; > " AND PROJ_HRS.wrk_hrs <> 0 " +; > "ORDER BY 1 " > >lcSqlStatement = "SELECT PROJ_HRS.* " +; > "FROM PROJ_HRS " +; > "WHERE PROJ_HRS.proj_cat_no IN ( 1, 3, 6 ) " +; > " AND PROJ_HRS.accepted = 0 " +; > " AND PROJ_HRS.refused = 0 " +; > " AND PROJ_HRS.atelier = 0 " +; > " AND PROJ_HRS.wrk_hrs <> 0 " +; > "ORDER BY 1 ">