<br>select SMR.*,CLD.mobile,CLD.name,CLD.email from `netshopv_console_urban`.`society_member_request` as SMR 
				  inner join `netshopv_console_signon`.`customer_login_details` as CLD on CLD.customer_id = SMR.customer_id				  
				  where SMR.society_id = "1" and SMR.id  = "1000" <pre>Array
(
    [id] => 1000
    [customer_id] => 2875
    [society_id] => 1
    [tower_name] => T5
    [flat_no] => 1406
    [resident_type] => TENANT
    [owner_name] => Yogender Singh Rathore
    [owner_mobile] => 7428397700
    [owner_email] => 
    [approved_status] => 1
    [request_date] => 2021-05-28 19:23:10
    [approved_by] => 13170003
    [approved_date] => 2021-06-29 21:01:12
    [mobile] => 9989355377
    [name] => Tushaar
    [email] => tushaarbajaj07@gmail.com
)
</pre><br>owner_id = 688<br>tenant_id = 1739<br>select count(*) as count from `netshopv_console_urban`.`society_resident_address`  where society_id = '1' and owner_id = '688'