Consulta Select

[tatis003]

Ola! tengo estas tres consultas pero necesito que se conviertan en una sola ... me pueden ayudar??

Código SQL:

SELECT Llenos.gran AS ID,Granja.nom_gran AS NOMBRE,Llenos.num_plan AS PLANILLA, Lote.id_lot AS LOTE,Llenos.cil_ent AS 'TOTAL CILINDROS',(SELECT SUM(pes_cil)FROM Llenos) AS 'PESO B.RETIRO',(SELECT SUM(pes_cil)FROM Llenos) 
AS 'PESO NO COSUMIDO',Planilla.num_com_plan AS 'O.COMPRA' FROM Llenos,Planilla,Granja,Lote WHERE id_plan=num_plan AND id_gran=gran;
 
SELECT Entrega.gran AS ID,Granja.nom_gran AS NOMBRE,Entrega.num_plan AS PLANILLA,   Lote.id_lot AS LOTE,Entrega.cil_ent AS 'TOTAL CILINDROS',
(SELECT SUM(pes_cil)FROM Entrega) AS 'PESO B.RETIRO',(SELECT SUM(pes_cil)FROM Entrega)  AS 'PESO NO COSUMIDO',Planilla.num_com_plan AS 'O.COMPRA'
FROM Entrega,Planilla,Granja,Lote WHERE id_plan=num_plan AND id_gran=gran;
 
SELECT Vacios.gran AS ID,Granja.nom_gran AS NOMBRE,Vacios.num_plan AS PLANILLA, Lote.id_lot AS LOTE,Vacios.cil_vac AS 'TOTAL CILINDROS',
(SELECT SUM(pes_cil)FROM Vacios) AS 'PESO B.RETIRO',(SELECT SUM(pes_cil)FROM Vacios) AS 'PESO NO COSUMIDO',Planilla.num_com_plan AS 'O.COMPRA'
FROM Vacios,Planilla,Granja,Lote WHERE id_plan=num_plan AND id_gran=gran;
 

[flaviovich]

¿Cuál es la relación entre Planilla y Granja?

[R3N0]

Supongo q con esto se resuelve tu problema.....sino es asi entonces explica un poco mas y con gusto te ayudamos





SELECT Llenos.gran AS ID,Granja.nom_gran AS NOMBRE,Llenos.num_plan AS PLANILLA, Lote.id_lot AS LOTE,Llenos.cil_ent AS 'TOTAL CILINDROS',(SELECT sum(pes_cil)FROM Llenos) AS 'PESO B.RETIRO',(SELECT sum(pes_cil)FROM Llenos)
AS 'PESO NO COSUMIDO',Planilla.num_com_plan AS 'O.COMPRA' FROM Llenos,Planilla,Granja,Lote WHERE id_plan=num_plan AND id_gran=gran;
union
SELECT Entrega.gran AS ID,Granja.nom_gran AS NOMBRE,Entrega.num_plan AS PLANILLA, Lote.id_lot AS LOTE,Entrega.cil_ent AS 'TOTAL CILINDROS',
(SELECT sum(pes_cil)FROM Entrega) AS 'PESO B.RETIRO',(SELECT sum(pes_cil)FROM Entrega) AS 'PESO NO COSUMIDO',Planilla.num_com_plan AS 'O.COMPRA'
FROM Entrega,Planilla,Granja,Lote WHERE id_plan=num_plan AND id_gran=gran;
union
SELECT Vacios.gran AS ID,Granja.nom_gran AS NOMBRE,Vacios.num_plan AS PLANILLA, Lote.id_lot AS LOTE,Vacios.cil_vac AS 'TOTAL CILINDROS',
(SELECT sum(pes_cil)FROM Vacios) AS 'PESO B.RETIRO',(SELECT sum(pes_cil)FROM Vacios) AS 'PESO NO COSUMIDO',Planilla.num_com_plan AS 'O.COMPRA'
FROM Vacios,Planilla,Granja,Lote WHERE id_plan=num_plan AND id_gran=gran;