日期:2014-05-17  浏览次数:20895 次

table合并问题
请教下

病人表
id                                                name
FAAB8080-BC3A-4A48-866E-C0C1B47F2D57             张三
8513DCB3-C9D8-4CBF-81D6-C54C43360109             李四
5247389A-36F6-4909-992A-A411A2B8BDD5             王五



病人检查单表
checkid                                                  sickerid(病人表主键id)
60BB0BB2-E0B5-4EB2-90A5-806A1EB37469        FAAB8080-BC3A-4A48-866E-C0C1B47F2D57
005B35F7-93BD-4738-8C53-236E73FADE2F        FAAB8080-BC3A-4A48-866E-C0C1B47F2D57
CD9A2DD9-8F01-4AAA-A8C5-C4E08C2F080A        8513DCB3-C9D8-4CBF-81D6-C54C43360109
52E59CBC-A3B4-4083-8F3F-04CD98BF2F89        5247389A-36F6-4909-992A-A411A2B8BDD5  




检查项目表1
checkid                                        chk1                        chk2
60BB0BB2-E0B5-4EB2-90A5-806A1EB37469          1.0                          2.0
005B35F7-93BD-4738-8C53-236E73FADE2F          2.0                          2.0
CD9A2DD9-8F01-4AAA-A8C5-C4E08C2F080A          3.0                          3.0
52E59CBC-A3B4-4083-8F3F-04CD98BF2F89          4.0                          4.0



检查项目表2
checkid                                        chk3                        chk4
60BB0BB2-E0B5-4EB2-90A5-806A1EB37469          11.0                          22.0
005B35F7-93BD-4738-8C53-236E73FADE2F      &nbs