摘要:
1.场景:主表一条数据,字表多条数据。需要查询时候展示一条,字表的数据用逗号分隔 sql语句: SELECT cdu.user_name as user_name, cmp.user_id as create_uid, cmr.receive_user_id as receive_user_id, 阅读全文
摘要:
1.原来的sql: SELECT t.city_id as cityId,t.city_name as cityName, t.group_id as groupId, t.supplier_name as supplierName,t.id,t.driver_name as driverName, 阅读全文