Left Join With Select

select sia_dasis.*,tax from sia_dasis left join (select sum(tax) as tax,b from sia_bill_list where owner='$owner->owner' group by b) tagih on sia_dasis.b = tagih.b where sia_dasis.owner='$owner->owner' and sia_dasis.b like '$a->b%' and sia_dasis.c like '%$a->c%' order by $urut ASC limit 50

SELECT b,c,d,f,g,h,nokk,kk

from des_daduk

left join

(select d as nokk,c as kk from des_daduk where q='1') tbkk

on des_daduk.d=tbkk.nokk

where des_daduk.c like '%masturi%'

other example

SELECT pro_client.*,COUNT(pro_invoice.client_id) as jml,t.tgl_sd from pro_client 
	left JOIN pro_invoice ON pro_client.idx = pro_invoice.client_id 
	LEFT JOIN (SELECT client_id,max(tgl_sd) as tgl_sd FROM pro_invoice  GROUP BY client_id) t  ON pro_client.idx = t.client_id
	GROUP BY pro_client.idx order by if(t.tgl_sd < '".date("Y-m-d")."' or t.tgl_sd ='' or t.tgl_sd is null,1,0),t.tgl_sd

Butuh solusi instan siap pakai?

Komentar

Kirim Komentar