csdn

“where is not null” 语句为什么不起作用？？？

left join (select CodeId,StdCode from CodeDetail where CodeGroupNo='MeterUseType') as rt on brbhth.LineType=rt.CodeId where brbhth.LineType is not null 这里的brbhth.LineType is not null ...