Select
costing.costingid,
clients.company_name as 'customer',
stock_items.item_code as 'product_code',
costing.costing_seq_number as 'costing_no',
costing.suggested_selling_price as 'quote_price~cur',
costing.date_costed as 'date'
From
costing
Left Join clients ON clients.clientsid = costing.clientsid
Left Join stock_items ON stock_items.stock_itemsid = costing.stock_itemsid