I have two tables
(Sales and monthly (monthly expenses).
I can summarize the value of sales and the amount of expenses separademente with the following query Sql
For Sale:
(SELECT
MONTHNAME (Datavenda) AS Month,
COUNT () AS Held,
Datavenda,
SUM (Commission) + SUM (margin) AS Sales
FROM sales
GROUP BY MONTHNAME (Datavenda), shop, MONTH (Datavenda)
Datavenda ORDER BY DESC)
For and Expenses:
(SELECT
MONTHNAME (DatadaDespesa) AS Month,
COUNT () AS Held,
SUM (Amount) AS expenses,
DatadaDespesa AS DatadaDespesa
FROM despesas_mensais
GROUP BY MONTHNAME (DatadaDespesa), MONTH (DatadaDespesa)
ORDER BY DESC DatadaDespesa)
Would join these two queries to show only on one page list?
thank you