select
b.id as WS_CODE,
b.id as WS_ODOO_ID,
b.name as WS_BranchName,
b.address as WS_ADDRESS,
rc.name as WS_CITY,
rcs.name as WS_STATE,
rpin.name as WS_ZIP_CODE,
rp.phone as WS_Contact,
rp.vat as WS_GSTNo,
rp.drug_licence20 as WS_DLNo1,
rp.drug_licence21 as WS_DLNo2,
1 as WS_COUNT_IN_STOCK,
b.name as BookingWareHouseName
from res_branch as b
left join res_partner as rp on b.partner_id = rp.id
left join res_city as rc on rc.id = rp.city_id
left join res_country_state as rcs on rcs.id = rp.state_id
left join res_zipcode as rpin on rpin.id = rp.zip_id
ORDER BY b.id;