Блог

как объединить эти таблицы, чтобы показать реальный результат.

 // table items and item_detail  $items = mysqli_query($conn,"select YEAR()as item_year,sum(quntity*buy_af)as item_total from items inner join item_detail on items.item_id=item_detail.item_id group by item_year");   // sales and sales_detail $sales = mysqli_query($conn,"select YEAR(sale_date)as sales_year,sum(quantity*sales_price)as sales_total from sales inner join sales_detail on sales.sales_id=sales_detail.sales_id group by sales_year");  // expenses $expense = mysqli_query($conn,"select YEAR(expense_date)as expense_year,sum(money)as expense_money from expenses group by expense_year");