fusion of 3 select

Question

fusion of 3 select

Navigation

#1 by (2 votes)
#2 by (1 votes)
#3 by (0 votes)

1

SELECT  vendedores.Nombre,SUM(factura.Total) FROM vendedores,factura 
WHERE 
vendedores.Codigo=factura.CodigoVendedor 
AND factura.Fecha BETWEEN '2018-09-13' AND '2018-09-14' GROUP BY 
vendedores.Nombre


SELECT  vendedores.Nombre,SUM(sales.Total) FROM vendedores,sales WHERE 
vendedores.Codigo=sales.CodigoVendedor 
AND sales.Fecha BETWEEN '2018-09-13' AND '2018-09-14' GROUP BY 
vendedores.Nombre



SELECT vendedores.Nombre,SUM(abonos.Abono) AS Total FROM 
vendedores,abonos,saldos WHERE abonos.NumFactura=saldos.NumFactura AND 
saldos.CodigoVendedor=vendedores.Codigo AND abonos.Fecha BETWEEN '2018- 
09-13' AND '2018-09-14' GROUP BY vendedores.Nombre

How do I make those 3 sum () of those 3 queries one? That is, to be able to obtain the result of those 3 summations.

mysql

asked by Richard Víquez Pérez 26.09.2018 в 04:51

source

3 answers

Add characters to a string in sql Can I know with SendGrid if an email arrives or does not reach its recipient when I send it?

score 2 · Answer 1

Try this select:

Selecr sum (*) from (
SELECT  SUM(factura.Total) valor FROM vendedores,factura 
WHERE 
vendedores.Codigo=factura.CodigoVendedor 
AND factura.Fecha BETWEEN '2018-09-13' AND '2018-09-14' GROUP BY 
vendedores.Nombre
Union
SELECT  SUM(sales.Total) valor2 FROM vendedores,sales WHERE 
vendedores.Codigo=sales.CodigoVendedor 
AND sales.Fecha BETWEEN '2018-09-13' AND '2018-09-14' GROUP BY 
vendedores.Nombre
Union
SELECT SUM(abonos.Abono) valor3 FROM 
vendedores,abonos,saldos WHERE abonos.NumFactura=saldos.NumFactura AND 
saldos.CodigoVendedor=vendedores.Codigo AND abonos.Fecha BETWEEN '2018- 
09-13' AND '2018-09-14' GROUP BY vendedores)a

score 1 · Answer 2

@ Alfredo Paz thank you very much I had already found the answer and if it is very similar to yours, I think that it is the same: SELECT v.Name, (SELECT SUM (invoice.Total) FROM invoice WHERE v.Code = invoice.CodeServer AND invoice.Type = 'Invoice' AND invoice.DATE BETWEEN '2018-09-13' AND '2018-09-14 'GROUP BY v.Name) + (SELECT SUM (sales.Total) FROM sales WHERE v.Codigo = sales.CodigoSeller AND sales.DATE BETWEEN' 2018-09-13 'AND' 2018-09-14 'GROUP BY v. Name) + (SELECT SUM (subscriptions.Abono) FROM subscriptions, balances WHERE subscriptions.NumFacture = balances.NumFacture AND balances.SelfCode = v.Code AND subscriptions.DATE BETWEEN '2018-09-13' AND '2018-09-14 'GROUP BY v.Name) as Total FROM sellers AS v

score 0 · Answer 3

Select sum (*) from (
SELECT  SUM(factura.Total) valor FROM vendedores,factura 
WHERE 
vendedores.Codigo=factura.CodigoVendedor 
AND factura.Fecha BETWEEN '2018-09-13' AND '2018-09-14' GROUP BY 
vendedores.Nombre
IN
'SELECT'  SUM(sales.Total) valor2 FROM vendedores,sales WHERE 
vendedores.Codigo=sales.CodigoVendedor 
AND sales.Fecha BETWEEN '2018-09-13' AND '2018-09-14' GROUP BY 
vendedores.Nombre
IN
'SELECT' SUM(abonos.Abono) valor3 FROM 
vendedores,abonos,saldos WHERE abonos.NumFactura=saldos.NumFactura AND 
saldos.CodigoVendedor=vendedores.Codigo AND abonos.Fecha BETWEEN '2018- 
09-13' AND '2018-09-14' GROUP BY vendedores)a