SQL 关联查询：结合两个表获取客户信息和货架信息

SELECT c.cus_id,c.contact_name,c.contact_phone_encrypt,c.contact_phone_new_encrypt,c.contact_position,c.data_flag,c.add_source,s.SHELF_ID,s.SHELF_CODE,s.SHELF_NAME,s.SHELF_STATUS,s.contact_name FROM fe_sell.se_cus_contact_info c INNER JOIN fe.sf_shelf s ON c.cus_id = s.cus_id WHERE c.cus_id = 139236 AND s.cus_id = 139236