1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| With LIGNES (NUMLIGNE, NUMDOC, ARTICLE, PRIX, QTE, INFO1, NUMCONT) as
(
select 1, 'BC00010', 'VELO' , 1000, 5, 'luxe', 784 union all
select 2, 'BC00054', 'SARDINE', 20, 1, 'real', null union all
select 3, 'FA08264', 'VELO' , 700, 5, 'luxe', 783
)
, CMLIENS (NUMINT, NUMCONTOUT, NUMCONTIN) as
(
select 1, 550, 549 union all
select 2, 784, 783
)
select l1.NUMLIGNE, l1.NUMDOC, l1.ARTICLE, l1.PRIX, l1.QTE, l1.INFO1, l1.NUMCONT
, l2.NUMLIGNE, l2.NUMDOC, l2.ARTICLE, l2.PRIX, l2.QTE, l2.INFO1, l2.NUMCONT
from CMLIENS as cl
join LIGNES as l1 on l1.NUMCONT = cl.NUMCONTOUT
join LIGNES as l2 on l2.NUMCONT = cl.NUMCONTIN
order by cl.numint asc;
NUMLIGNE NUMDOC ARTICLE PRIX QTE INFO1 NUMCONT NUMLIGNE NUMDOC ARTICLE PRIX QTE INFO1 NUMCONT
----------- ------- ------- ----------- ----------- ----- ----------- ----------- ------- ------- ----------- ----------- ----- -----------
1 BC00010 VELO 1000 5 luxe 784 3 FA08264 VELO 700 5 luxe 783 |
Partager