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%'
Tidak ada komentar:
Posting Komentar