1、sql 一对多 出一条结果及两列选择一个的方法:
select m.* , nvl(a.name,m.id_1) id1 , nvl(b.name,m.id_2)
from mleft join his a on m.id_1 = a.id
left join his b on m.id_2 = b.id
2、null值设置默认值
sqlserver:
select isnull(字段名, '复制) from table
Oracle:
select nvl(sum(t.字段),1) from table t