1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| select Oppo.D_DISCUSS
,inv.TOTAL_NO_VAT
,budget.F_CESURE1
,budget.F_CESURE2
,budget.F_CESURE3
,budget.F_CESURE4
from OPPO$BUDGET as budget
join OPPORTUNITIES as Oppo on Oppo.K_OPPORTUNITY = budget.K_OPPORTUNITY and Oppo.K_USER=2
join DOCU_OPPO as DO on DO.K_OPPORTUNITY=Oppo.K_OPPORTUNITY
join DOCUMENTS as Docu on DO.K_DOCUMENT=Docu.K_DOCUMENT and Docu.REFERENCE like 'D%'
join DOCU$INVOICING as inv on DO.K_DOCUMENT=inv.K_DOCUMENT
select Oppo.D_DISCUSS
,inv.TOTAL_NO_VAT
,budget.F_CESURE1
,budget.F_CESURE2
,budget.F_CESURE3
,budget.F_CESURE4
from OPPO$BUDGET as budget
join OPPORTUNITIES as Oppo on Oppo.K_OPPORTUNITY = budget.K_OPPORTUNITY
join DOCU_OPPO as DO on DO.K_OPPORTUNITY=Oppo.K_OPPORTUNITY
join DOCUMENTS as Docu on DO.K_DOCUMENT=Docu.K_DOCUMENT
join DOCU$INVOICING as inv on DO.K_DOCUMENT=inv.K_DOCUMENT
where Docu.REFERENCE like 'D%'
and Oppo.K_USER=2 |
Partager