求助动态时间合并

[99129727]

SELECT t0.* ,
( SELECT xl FROM uf_zxsgzjh t1 WHERE t0.xl = t1.id )+(SELECT lb FROM uf_sglb t1 WHERE t0.zydm = t1.id)+'-'+ (select distinct right( replace (rq,'-',''),4) from uf_sgzjh1 where id=100 )+'-'+ xhn AS "作业代码" ,
(SELECT departmentname FROM hrmdepartment t1 WHERE t0.sqdw = t1.id ) AS '申请单位',
zykssj + '-' + zyjssj AS "作业时间" ,
(SELECT ztlk FROM uf_ztwh t1 WHERE t0.zyksqy = t1.id ) + '-' + ( SELECT ztlk FROM uf_ztwh t1 WHERE t0.zyjsqy = t1.id ) AS "作业区域" ,
zynr AS "作业内容" ,
(SELECT xq FROM uf_phyq t1 WHERE t0.gdyq = t1.id )AS "供电需求",
fhcs AS "防护措施",
( SELECT xq FROM uf_phyq t1 WHERE t0.phyq = t1.id )AS "配合要求",
( SELECT lastname FROM hrmresource t1 WHERE t0.sbr = t1.id ) AS '申报人' ,
sbrlxfs AS "联系方式" ,
( SELECT lastname FROM hrmresource t1 WHERE t0.fzr = t1.id ) AS '负责人',
fzrlxfs AS "联系方式",
zyrs AS "作业人数",
bz AS "备注"
FROM uf_sgzjh1 t0

作业代码=zydm+rq+xh
多个日期一一对应作业代码中的日期

[二月十六]

建议楼主列出表结构，并提供测试数据以及基于这些测试数据的所对应正确结果。 参考一下这个贴子的提问方式http://bbs.csdn.net/topics/320211382 1. 你的 create table xxx .. 语句 2. 你的 insert into xxx ... 语句 3. 结果是什么样，（并给以简单的算法描述） 4. 你用的数据库名称和版本(经常有人在MS SQL server版问 MySQL)

[99129727]

自己搞定了，谢谢