SELECT CLI.DOS, CLI.TIERS, CLI.NOM, CLI.REPR_0001, ENT.PICOD, ENT.PINO, ENT.PIDT, ENT.HTMT, ENT.TTCMT, CLI.USERCRDH, CLI.CPOSTAL, CLI.VIL
FROM CARTOFLEX.dbo.CLI CLI, CARTOFLEX.dbo.ENT ENT
WHERE ENT.TIERS = CLI.TIERS AND ((CLI.DOS=1) AND (ENT.PICOD=4) AND (ENT.PIDT>'2015-01-01' And ENT.PIDT<'2015-12-31'))









--	Commandes en cours
SELECT CLI.DOS, CLI.TIERS, CLI.NOM, CLI.CPOSTAL, CLI.REPR_0001, ENT.PIDT, ENT.DELDEMDT, ENT.PINO, ENT.PINOTIERS, ENT.PIREF, ENT.HTMT
FROM CARTOFLEX.dbo.CLI CLI, CARTOFLEX.dbo.ENT ENT
WHERE ENT.TIERS = CLI.TIERS AND ((CLI.DOS=1) AND (ENT.PICOD=2) AND (ENT.CE4='1'))



--	Commandes par mois
SELECT 
CLI.DOS, 
CLI.TIERS, 
CLI.NOM, 
ENT.PIDT, 
ENT.PINO, 
ENT.PINOTIERS, 
ENT.PIREF, 
CLI.REPR_0001, 
ENT.STATUS, 
ENT.CONTACT, 
ENT.HTMT, 
ENT.TTCMT, 
CLI.DOS 
FROM CARTOFLEX.dbo.CLI CLI, CARTOFLEX.dbo.ENT ENT
WHERE ENT.TIERS = CLI.TIERS 
AND ((CLI.DOS=1) AND (ENT.PICOD=2) 
AND (CLI.REPR_0001='ACS')) 
AND (ENT.PIDT Between '2022-01-01' And '2022-03-21') 
AND CLI.TIERS LIKE 'P%'




--	Commandes par mois complexe
SELECT 
CLI.DOS, 
CLI.TIERS, 
CLI.NOM, 
ENT.PIDT, 
ENT.PINO, 
ENT.PINOTIERS, 
ENT.PIREF, 
CLI.REPR_0001, 
ENT.STATUS, 
ENT.CONTACT, 
ENT.HTMT, 
ENT.TTCMT, 
CLI.DOS
FROM {oj CARTOFLEX.dbo.ENT ENT LEFT OUTER JOIN CARTOFLEX.dbo.CLI CLI ON ENT.TIERS = CLI.TIERS}
WHERE CLI.DOS = ENT.DOS 
AND ((ENT.TICOD='C') 
AND (ENT.DOS=1) AND (ENT.PICOD=1) 
AND (ENT.CE4='1') 
OR (ENT.TICOD='P') 
AND (ENT.DOS=1) 
AND (ENT.PICOD=1) 
AND (ENT.CE4='1')) 
AND (CLI.REPR_0001='ACS') 
AND (ENT.PIDT Between '2022-01-01' And '2022-03-21') 





SELECT * 
FROM CARTOFLEX.dbo.ENT ENT 
WHERE ENT.DOS=1 
AND (ENT.PIDT Between '2023-01-01' And '2023-03-02')