MySQL Two select in a query

0

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.

    
asked by Kowee Minuit 04.05.2018 в 21:53
source

0 answers