oracle合并行

SinceDayOne

于 2013-11-14 11:32:04 发布

阅读量186

点赞数

分类专栏： sql

本文链接：https://blog.youkuaiyun.com/renjiangfeng3/article/details/16114543

版权

sql 专栏收录该内容

1 篇文章

订阅专栏

SELECT uul.user_log_id,
       uul.object_user_id,
       uul.object_login_name,
       uul.operate_user_id,
       uul.operate_login_name,
       uul.create_time, 
       replace(wmsys.wm_concat (uulp.description),',','') as description
FROM um_user_log uul, ddc_user_log_type dult, um_user_log_property uulp
where uul.user_log_type = dult.code 
 and uul.user_log_type = '02010112'
 and uul.user_log_id = uulp.user_log_id
GROUP BY uul.user_log_id,
       uul.object_user_id,
       uul.object_login_name,
       uul.operate_user_id,
       uul.operate_login_name,
       uul.create_time