Deux select dans une requete
simo
-
phunk Messages postés 500 Date d'inscription Statut Membre Dernière intervention -
phunk Messages postés 500 Date d'inscription Statut Membre Dernière intervention -
Bonjour,
j'ai un petit probleme, je travail sous sql server, j'ai deux requetes sql avec deux select, est ce que c possible de faire une requete avec les deux select.... sachant que la clé primaire est F090KY, et la table est F090PARC
la premiere requete :
SELECT DISTINCT
LTRIM(RTRIM(dbo.F091IMMAT.F091IMMA)) AS Expr1, dbo.F090PARC.F090KY, LTRIM(RTRIM(dbo.F090PARC.F090SERIE))
AS Expr2, dbo.F090PARC.K090001SOC, dbo.F090PARC.K090060MOD, dbo.F061MODINF.K061T03MARQ, dbo.TAR060.T06PRIMMOD, dbo.TAR060.T06SOUSMOD,
dbo.F090PARC.F090COULEUR, CAST(YEAR(dbo.F090PARC.F090DTMISC) AS varchar) + RIGHT('0' + CAST(MONTH(dbo.F090PARC.F090DTMISC)
AS varchar), 2) + RIGHT('0' + CAST(DAY(dbo.F090PARC.F090DTMISC) AS varchar), 2) AS Expr3, CAST(YEAR(dbo.F470LD.F470DTDEP) AS varchar)
+ RIGHT('0' + CAST(MONTH(dbo.F470LD.F470DTDEP) AS varchar), 2) + RIGHT('0' + CAST(DAY(dbo.F470LD.F470DTDEP) AS varchar), 2) AS Expr4,
CAST(YEAR(dbo.F470LD.F470DTARRP) AS varchar) + RIGHT('0' + CAST(MONTH(dbo.F470LD.F470DTARRP) AS varchar), 2)
+ RIGHT('0' + CAST(DAY(dbo.F470LD.F470DTARRP) AS varchar), 2) AS Expr5, dbo.F061MODINF.K061T02ENE, dbo.TAR060.T06BVMOD,
dbo.F061MODINF.F061CYLIN, dbo.F470LD.F470KMAFF, F050TIERS_1.F050NOM, F022MCOM_2.F022NUM, dbo.F470LD.F470CONTRAT,
F022MCOM_1.F022NUM AS Expr6, F022MCOM_3.F022NUM AS Expr7, dbo.F090PARC.F090KM, dbo.F057CPTA.K057305CPTE,
dbo.TAR540.T54OKPNEHIV, dbo.F470LD.F470NBPNEUS, dbo.F470LD.F470NBPNEUSHIV, dbo.TAR060.T06TAIPNEU, dbo.TAR060.T06TAIJAN,
dbo.TAR060.T06VITPNEU
FROM dbo.F090PARC INNER JOIN
dbo.F091IMMAT ON dbo.F090PARC.K090091IMM = dbo.F091IMMAT.F091KY INNER JOIN
dbo.F570MVT ON dbo.F570MVT.K570090UNI = dbo.F090PARC.F090KY INNER JOIN
dbo.F470LD ON dbo.F570MVT.F570KY = dbo.F470LD.K470570MVT INNER JOIN
dbo.F050TIERS ON dbo.F470LD.K470050TIE = dbo.F050TIERS.F050KY INNER JOIN
dbo.F020ADR ON dbo.F020ADR.F020KY = dbo.F050TIERS.K050020ADR INNER JOIN
dbo.F060MOD ON dbo.F090PARC.K090060MOD = dbo.F060MOD.F060KY INNER JOIN
dbo.F061MODINF ON dbo.F061MODINF.F061KY = dbo.F090PARC.K090061MOD INNER JOIN
dbo.TAR510 ON dbo.F470LD.F470CONTRAT = dbo.TAR510.T51NUMDEV INNER JOIN
dbo.TAR060 ON dbo.TAR510.T51CODMOD = dbo.TAR060.T06CODMOD INNER JOIN
dbo.TAR540 ON dbo.TAR510.T51NUMDEV = dbo.TAR540.T54NUMDEV LEFT OUTER JOIN
dbo.F050TIERS F050TIERS_1 ON dbo.F470LD.K470050CON = F050TIERS_1.F050KY LEFT OUTER JOIN
dbo.F057CPTA ON dbo.F050TIERS.F050KY = dbo.F057CPTA.K057050KY AND dbo.F057CPTA.K057305CPTE LIKE '%_C%' LEFT OUTER JOIN
dbo.F022MCOM F022MCOM_1 ON dbo.TAR510.T51NUMPROS = F022MCOM_1.F022NNNKY AND F022MCOM_1.K022T22TYP = '2' LEFT OUTER JOIN
dbo.F022MCOM F022MCOM_2 ON dbo.TAR510.T51NUMPROS = F022MCOM_2.F022NNNKY AND F022MCOM_2.K022T22TYP = '1' LEFT OUTER JOIN
dbo.F022MCOM F022MCOM_3 ON dbo.F470LD.K470050CON = F022MCOM_3.F022NNNKY AND F022MCOM_3.K022T22TYP = '1'
WHERE (dbo.F470LD.K470T37ETA = '3') AND (dbo.F090PARC.K090T58POS NOT IN ('vendu', 'venduvo')) AND
(dbo.F470LD.K470T37ETA NOT IN ('9'))
la deuxieme :
SELECT dbo.F090PARC.F090KY, CAST(SUM(dbo.F410LIG.F410QT) AS integer) AS Expr1, dbo.F090PARC.K090001SOC
FROM dbo.F410LIG INNER JOIN
dbo.F400EVT ON dbo.F410LIG.K410400EVT = dbo.F400EVT.F400KY INNER JOIN
dbo.F41YSTATUT ON dbo.F410LIG.F410KY = dbo.F41YSTATUT.F41Y410LIG INNER JOIN
dbo.F090PARC ON dbo.F410LIG.K410090UNI = dbo.F090PARC.F090KY
WHERE (dbo.F41YSTATUT.K41YTJ4STATU = 'TOTAL') AND (dbo.F410LIG.K410100PRO IN ('103.1', '120', '104.1', '121'))
GROUP BY dbo.F090PARC.F090KY, dbo.F090PARC.K090001SOC
j'ai un petit probleme, je travail sous sql server, j'ai deux requetes sql avec deux select, est ce que c possible de faire une requete avec les deux select.... sachant que la clé primaire est F090KY, et la table est F090PARC
la premiere requete :
SELECT DISTINCT
LTRIM(RTRIM(dbo.F091IMMAT.F091IMMA)) AS Expr1, dbo.F090PARC.F090KY, LTRIM(RTRIM(dbo.F090PARC.F090SERIE))
AS Expr2, dbo.F090PARC.K090001SOC, dbo.F090PARC.K090060MOD, dbo.F061MODINF.K061T03MARQ, dbo.TAR060.T06PRIMMOD, dbo.TAR060.T06SOUSMOD,
dbo.F090PARC.F090COULEUR, CAST(YEAR(dbo.F090PARC.F090DTMISC) AS varchar) + RIGHT('0' + CAST(MONTH(dbo.F090PARC.F090DTMISC)
AS varchar), 2) + RIGHT('0' + CAST(DAY(dbo.F090PARC.F090DTMISC) AS varchar), 2) AS Expr3, CAST(YEAR(dbo.F470LD.F470DTDEP) AS varchar)
+ RIGHT('0' + CAST(MONTH(dbo.F470LD.F470DTDEP) AS varchar), 2) + RIGHT('0' + CAST(DAY(dbo.F470LD.F470DTDEP) AS varchar), 2) AS Expr4,
CAST(YEAR(dbo.F470LD.F470DTARRP) AS varchar) + RIGHT('0' + CAST(MONTH(dbo.F470LD.F470DTARRP) AS varchar), 2)
+ RIGHT('0' + CAST(DAY(dbo.F470LD.F470DTARRP) AS varchar), 2) AS Expr5, dbo.F061MODINF.K061T02ENE, dbo.TAR060.T06BVMOD,
dbo.F061MODINF.F061CYLIN, dbo.F470LD.F470KMAFF, F050TIERS_1.F050NOM, F022MCOM_2.F022NUM, dbo.F470LD.F470CONTRAT,
F022MCOM_1.F022NUM AS Expr6, F022MCOM_3.F022NUM AS Expr7, dbo.F090PARC.F090KM, dbo.F057CPTA.K057305CPTE,
dbo.TAR540.T54OKPNEHIV, dbo.F470LD.F470NBPNEUS, dbo.F470LD.F470NBPNEUSHIV, dbo.TAR060.T06TAIPNEU, dbo.TAR060.T06TAIJAN,
dbo.TAR060.T06VITPNEU
FROM dbo.F090PARC INNER JOIN
dbo.F091IMMAT ON dbo.F090PARC.K090091IMM = dbo.F091IMMAT.F091KY INNER JOIN
dbo.F570MVT ON dbo.F570MVT.K570090UNI = dbo.F090PARC.F090KY INNER JOIN
dbo.F470LD ON dbo.F570MVT.F570KY = dbo.F470LD.K470570MVT INNER JOIN
dbo.F050TIERS ON dbo.F470LD.K470050TIE = dbo.F050TIERS.F050KY INNER JOIN
dbo.F020ADR ON dbo.F020ADR.F020KY = dbo.F050TIERS.K050020ADR INNER JOIN
dbo.F060MOD ON dbo.F090PARC.K090060MOD = dbo.F060MOD.F060KY INNER JOIN
dbo.F061MODINF ON dbo.F061MODINF.F061KY = dbo.F090PARC.K090061MOD INNER JOIN
dbo.TAR510 ON dbo.F470LD.F470CONTRAT = dbo.TAR510.T51NUMDEV INNER JOIN
dbo.TAR060 ON dbo.TAR510.T51CODMOD = dbo.TAR060.T06CODMOD INNER JOIN
dbo.TAR540 ON dbo.TAR510.T51NUMDEV = dbo.TAR540.T54NUMDEV LEFT OUTER JOIN
dbo.F050TIERS F050TIERS_1 ON dbo.F470LD.K470050CON = F050TIERS_1.F050KY LEFT OUTER JOIN
dbo.F057CPTA ON dbo.F050TIERS.F050KY = dbo.F057CPTA.K057050KY AND dbo.F057CPTA.K057305CPTE LIKE '%_C%' LEFT OUTER JOIN
dbo.F022MCOM F022MCOM_1 ON dbo.TAR510.T51NUMPROS = F022MCOM_1.F022NNNKY AND F022MCOM_1.K022T22TYP = '2' LEFT OUTER JOIN
dbo.F022MCOM F022MCOM_2 ON dbo.TAR510.T51NUMPROS = F022MCOM_2.F022NNNKY AND F022MCOM_2.K022T22TYP = '1' LEFT OUTER JOIN
dbo.F022MCOM F022MCOM_3 ON dbo.F470LD.K470050CON = F022MCOM_3.F022NNNKY AND F022MCOM_3.K022T22TYP = '1'
WHERE (dbo.F470LD.K470T37ETA = '3') AND (dbo.F090PARC.K090T58POS NOT IN ('vendu', 'venduvo')) AND
(dbo.F470LD.K470T37ETA NOT IN ('9'))
la deuxieme :
SELECT dbo.F090PARC.F090KY, CAST(SUM(dbo.F410LIG.F410QT) AS integer) AS Expr1, dbo.F090PARC.K090001SOC
FROM dbo.F410LIG INNER JOIN
dbo.F400EVT ON dbo.F410LIG.K410400EVT = dbo.F400EVT.F400KY INNER JOIN
dbo.F41YSTATUT ON dbo.F410LIG.F410KY = dbo.F41YSTATUT.F41Y410LIG INNER JOIN
dbo.F090PARC ON dbo.F410LIG.K410090UNI = dbo.F090PARC.F090KY
WHERE (dbo.F41YSTATUT.K41YTJ4STATU = 'TOTAL') AND (dbo.F410LIG.K410100PRO IN ('103.1', '120', '104.1', '121'))
GROUP BY dbo.F090PARC.F090KY, dbo.F090PARC.K090001SOC
A voir également:
- Deux select dans une requete
- Comment faire deux colonnes indépendantes dans word - Guide
- Nombre de jours entre deux dates excel - Guide
- Deux ecran pc - Guide
- Deux whatsapp sur un téléphone - Guide
- J'ai deux compte facebook avec la meme adresse mail ✓ - Forum Facebook