如果在此表中不存在记录，我希望在每列中显示空值我该怎么做 [英] I Want Null To Display In Every Column If Record Is Not Present In This Table How Do I Do It

问题描述

SELECT TWCI_Job_Code,TWCI_Warehouse_code,SUM((TWCI_Quantity)) from SQLSCM.SCM_T_Warehouse_Cumulative_Issues
                                           where TWCI_Job_Code='mbbh7533' and TWCI_Warehouse_code=2668 and TWCI_Material_Code='109931300' and
                                           TWCI_Stock_Type_Code=4 and TWCI_Stock_Type_Detail_Code=11 and TWCI_Company_code=1 and
                                            TWCI_Start_Date>='2015-04-01' and TWCI_End_Date<='2015-04-28'
                                            GROUP BY TWCI_Job_Code,TWCI_Warehouse_code

推荐答案

你将不得不做一个 EXISTS（） [ ^ ]检查，以及什么都没有，特别是返回空值

选择NULL为TWCI_Job_Code，NULL为TWCI_Warehouse_code

you'll have to do an EXISTS()[^] check, and of you get nothing, specifically return nulls
select NULL as TWCI_Job_Code, NULL as TWCI_Warehouse_code

这篇关于如果在此表中不存在记录，我希望在每列中显示空值我该怎么做的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！