select so.sale_order_id,so.date,c.customer_name,c.customer_code ,so.sale_order_no, i.item_code as "Product ID", i.art_no as "Item Code",i.brand from 0p4_sale_order so
left join 0p4_sale_order_detail sod on sod.sale_order_id=so.sale_order_id
left join 0p4_item i on i.item_id=sod.item_id
left join 0p4_customer on c.customer_id=sod.customer_id
where i.brand='PROMO PACK'