i am considering first table is having customer_id

select t1.shortname+' '+t3.quotation_date from  tbl_partnerhirerege t1 join tbl_quotation t2 on t1.customer_id=t2.customer_id

join tbl_quotation_master t3 on t2.customer_id=t3.customer_id

let me know the result