union all
union all 和isnull
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
SELECT dbo.FEE_IN.ID ,
cast(0 as bit) as choice,
'应收' as class,
dbo.JOB_SE.JOBNO,
dbo.PD_FEEITEM.FEEITEM_CNAME,
dbo.PD_COMPANY.COMP_C_CNAME,
dbo.FEE_IN.CURRENCY,
dbo.FEE_IN.AMOUNT,
dbo.FEE_IN.PRICE,
dbo.FEE_IN.NUMERIC,
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
dbo.FEE_IN.FLAG_SH,
dbo.FEE_IN.FLAG_KP,
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
dbo.FEE_IN.INVOICE_NO,
dbo.FEE_IN.JSMODE
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
FROM
dbo.FEE_IN LEFT OUTER JOIN dbo.PD_COMPANY
ON dbo.FEE_IN.COMPANY_ID = dbo.PD_COMPANY.ID
LEFT OUTER JOIN dbo.PD_FEEITEM
ON dbo.FEE_IN.FEEITEM_ID = dbo.PD_FEEITEM.ID
LEFT OUTER JOIN dbo.JOB_SE
ON dbo.FEE_IN.PARENTID=dbo.JOB_SE.ID
where dbo.FEE_IN.FLAG_SH = '1' and isnull(FLAG_KP,'')='0'
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
union all
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
SELECT dbo.FEE_OUT.ID ,
cast(0 as bit) as choice,
'应付' as class,
dbo.JOB_SE.JOBNO,
dbo.PD_FEEITEM.FEEITEM_CNAME,
dbo.PD_COMPANY.COMP_C_CNAME,
dbo.FEE_OUT.CURRENCY,
dbo.FEE_OUT.AMOUNT,
dbo.FEE_OUT.PRICE,
dbo.FEE_OUT.NUMERIC,
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
dbo.FEE_OUT.FLAG_SH,
dbo.FEE_OUT.FLAG_KP,
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
dbo.FEE_OUT.INVOICE_NO,
dbo.FEE_OUT.JSMODE
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
FROM
dbo.FEE_OUT LEFT OUTER JOIN dbo.PD_COMPANY
ON dbo.FEE_OUT.COMPANY_ID = dbo.PD_COMPANY.ID
LEFT OUTER JOIN dbo.PD_FEEITEM
ON dbo.FEE_OUT.FEEITEM_ID = dbo.PD_FEEITEM.ID
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
LEFT OUTER JOIN dbo.JOB_SE
ON dbo.FEE_OUT.PARENTID=dbo.JOB_SE.ID
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
where dbo.FEE_out.FLAG_SH = '1' and isnull(FLAG_KP,'')='0'
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
";
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)