$joinQuery apply LEFT JOIN but cannot show join table’s valuable
<?php $table = ‘fchan_mc_ee_hw’; $primaryKey = ‘id’; $columns = array( array( ‘db’ => ‘`s`.`surname`’, ‘dt’ => 0, ‘field’ => ‘sid’ ), array( ‘db’ => ‘`h`.`officer_id`’, ‘dt’ => 1, ‘field’ => ‘officer_id’ ), array( ‘db’ => ‘sum(if (`h`.`mc_ee_level_id` = 1,1,0 ))’, ‘dt’ => 2, ‘field’ =>’sum_of_L1′, ‘as’ => ‘sum_of_L1’ ), array( ‘db’ => ‘sum(if (`h`.`mc_ee_level_id` = … Continue reading $joinQuery apply LEFT JOIN but cannot show join table’s valuable
Copy and paste this URL into your WordPress site to embed
Copy and paste this code into your site to embed