select a.C001,a.C006,a.C012,b.C005,b.C009 case when b.C009='1' then '逗B' end from T_21_001 a full join T_31_019_00000 b on a.C002=b.C003-- case 前面少一个逗号select a.C001,a.C006,a.C012,b.C005,b.C009 , case when b.C009='1' then '逗B' end from T_21_001 a full join T_31_019_00000 b on a.C002=b.C003
select a.C001,a.C006,a.C012,b.C005,case when b.C009='1' then '逗B' end from T_21_001 a full join T_31_019_00000 b on a.C002=b.C003 去掉case前面的b.C009
select a.C001,a.C006,a.C012,b.C005,b.C009 case when b.C009='1' then '逗B' end from T_21_001 a full join
T_31_019_00000 b on a.C002=b.C003-- case 前面少一个逗号select a.C001,a.C006,a.C012,b.C005,b.C009 , case when b.C009='1' then '逗B' end from T_21_001 a full join
T_31_019_00000 b on a.C002=b.C003
T_31_019_00000 b on a.C002=b.C003 去掉case前面的b.C009