My Mysql query is as follows:
SELECT MONTHNAME(FCH_ABST) as MES,
YEAR(FCH_ABST) as ANIO,
TTL_VNTS AS MQ01
FROM maquina6_abastos
WHERE NM_MQ = 111
AND FCH_ABST BETWEEN '2018-01-01' AND '2018-04-30'
What this table returns to me as a result:
MES ANIO MQ01
January 2018 80
March 2018 180
April 2018 95
Now I want to add a sub query for another column that is called MQ02 with the following script:
SELECT MONTHNAME(FCH_ABST) as MES,
YEAR(FCH_ABST) as ANIO,
(SELECT TTL_VNTS
FROM maquina6_abastos
WHERE NM_MQ = 111
) as ventasMes1,
(
SELECT TTL_VNTS
FROM maquina6_abastos
WHERE NM_MQ = 112
) as ventasMes2
FROM maquina6_abastos
WHERE FCH_ABST BETWEEN '2018-01-01' AND '2018-04-30'
GROUP BY DATE_FORMAT(FCH_ABST,'%m-%Y')
ORDER BY FCH_ABST
The database has the following structure:
NM_MQ TTL_VNTS FCH_ABST
110 50 2018-01-01
110 30 2018-01-15
110 100 2018-03-01
110 80 2018-03-15
110 92 2018-04-15
111 40 2018-01-01
111 20 2018-01-15
111 90 2018-03-01
111 50 2018-03-15
111 60 2018-04-15
112 10 2018-01-01
112 30 2018-01-15
112 40 2018-03-01
112 70 2018-03-15
112 50 2018-04-15
Which gives me the error # 1242 "Subquery returns more than one line". Actually I hope to get three columns called MQ01, MQ02, MQ03 But I could not get past this point. I would appreciate any guidance.