Select
quotations.quotationsid,
quotations.quotationsid as Quotation_no,
quotations.new_order_requestsid as new_order_requests_id,
quotations.`order_number`,
clients.company_name as Client,
quotations.`date` as issued_date,
quotations.`go_ahead`
From
quotations
Inner Join clients ON clients.clientsid = quotations.clientsid
Inner Join contact_person ON contact_person.contact_personid = quotations.contact_personid