时间戳

首页 > 解决方案 > 如何在相同条件下从 2 表中获取值

php - 如何在相同条件下从 2 表中获取值

问题描述

我有 2 个表，t_silm 和 t_revenue，我想对具有相同条件的两个表求和。这是我的表示例：

https://ibb.co/JtCp80w

t_silm

bl - th - tw - total
10 - 2018 - 4 - 100
11 - 2018 - 4 - 200
12 - 2018 - 4 - 300


t_revenue

bl - th - tw - jumlah
10 - 2018 - 4 - 25
11 - 2018 - 4 - 70
12 - 2018 - 4 - 45

我想得到结果：

avg = total / jumlah;

condition =  tw =4 and th = 2018;

请问有人可以帮我吗？

$query = "SELECT sum(t_slim.pemakaian_309) as to1, sum(t_revenue.jumlah) as to2, to1/to2 as taverage 
            from t_slim t1 INNER JOIN t_revenue t2 on t1.tahun=t2.tahun 
            and t1.triwulan=t2.triwulan WHERE t1.tahun=$tahun and t1.triwulan=$triwulan GROUP BY bulan";
  
  $hasil = mysql_query($query);
  $baris = 3;
   while ($data = mysql_fetch_array($hasil))
  {
  $worksheet2->write_string(11, $baris, number_format($data['taverage'],2),$format2);
  $baris++;  
  }

标签： phpmysql

解决方案

试试这个查询

SELECT t1.total as total1, t2.total as total2, total1/total2 as total_avg 
from t_slim t1 INNER JOIN t_revenue t2 on t1.th=t2.th 
and t2.tw=t1.tw WHERE t1.th=2018 and t1.tw=4

推荐阅读