I have 3 working independently query, how I can but them as one
SELECT * , SUM(summa) AS papp9 FROM rent WHERE liige_id = 9 AND date > NOW()
SELECT * , SUM(summa) AS papp8 FROM rent WHERE liige_id = 8 AND date > NOW()
SELECT * , SUM(summa) AS papp7 FROM rent WHERE liige_id = 7 AND date > NOW()
try this:
SELECT * , SUM(summa) AS papp FROM rent WHERE date > NOW()
group by liige_id
SELECT *, SUM(summa) AS papp9
FROM rent
WHERE liige_id IN (7,8,9)
AND date > NOW()
GROUP BY liige_id