select cvr.customer_id,  cvr.address_label, cvr.vendor_name, cvr.vendor_id, vhd.locality, vhd.area, vhd.address,
 vhd.city, vhd.state from cust_vend_relation cvr, vendor_home_delivery vhd
where cvr.vendor_id = vhd.vendor_id and cvr.address_label = 'Office' and cvr.customer_id = 3;