1 2 3
| select L.aid, L.pid,L.task,L.item,P.name,T.taskname,L.week,L.monday,L.tuesday,L.wednesday,L.thursday,L.friday from loads L inner join projects P on (P.pid = L.pid) inner join tasks T on (T.tid = L.task) where L.week between '18' and '22' and P.name!='_Non Chargeable Activity' and L.total>0 order by P.name,L.pid,L.task,L.item
NOT IN
(select L.aid, L.pid,L.task,L.item,P.name,T.taskname,L.week,L.monday,L.tuesday,L.wednesday,L.thursday,L.friday from loads L inner join projects P on (P.pid = L.pid) inner join tasks T on (T.tid = L.task) where L.week between '14' and '17' and P.name!='_Non Chargeable Activity' and L.total>0 order by P.name,L.pid,L.task,L.item); |
Partager