Consultas SELECT

tatis003 · #1 (**permalink**) 19/02/2010, 14:26

Estas son las consultas que hiice y Kiiero uniirlas es un solo "select"...

Código SQL:
Ver original
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;

huesos52 · #2 (**permalink**) 19/02/2010, 14:32

Con tan pocos detalles te recomiendo el operador UNION.

saludos

tatis003 · #3 (**permalink**) 19/02/2010, 14:42

Miira estas son las consultas que hiice y pos kiiero uniirlas...

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;