SQL 过滤null 值

Select a.NClassId,b.NClassName From p_MarketActionLimit as a left join p_NClass as b on a.NClassId = b.NClassID where a.MarketId = @MarketId and b.NClassName is not null group by a.NClassId,b.NClassName

列 is not  null 

posted @ 2018-06-07 15:41  冬月二四  阅读(2525)  评论(0编辑  收藏  举报