sales report

select sd_headers.dr_date as date, sd_headers.id as dr_id, partners.name as partner_name, item_categories.name as item_cat, item_subcategories.name as item_sub_cat,
sd_details.price as amount, 
(
	select sum(bill_sub_details.amount) from bill_sub_details
INNER JOIN bill_headers on bill_sub_details.bill_id = bill_headers.id
where bill_headers.status in ('Approved','Printed')
and bill_sub_details.dr_id = sd_details.dr_id
) as bill
 from sd_details
inner join sd_headers on sd_details.dr_id = sd_headers.id
INNER JOIN items on sd_details.item_id = items.id
LEFT JOIN item_categories on items.category_id = item_categories.id
LEFT JOIN item_subcategories on items.subcategory_id = item_subcategories.id
INNER JOIN partners on sd_headers.partner_id = partners.id
where sd_headers.status = 'Finalized' and sd_headers.a_status in ('1','2')
and sd_details.item_id = 1223