Access outbound combined null values, resulting in inventory null values, receiving the tao and the-CodePudding

The original ID goods inventory inventory combined dispatch total inventory specifications
1 100 300 150 250 bottles of red
2 green 200 bottles of 100
3 yellow 100 bottles of 100
4 blue 100, 100, 100, 100 bottles of

SELECT DISTINCTROW inventory detail. ID, inventory detail. Goods, inventory detail. Specifications, inventory detail. The original inventory, the Sum ([stock] + [storage aggregate] - [outbound combined]) AS inventories, into one summary. Combined storage aggregate AS warehousing, 1 summary. Outbound combined AS outbound combined
The FROM (inventory detail LEFT JOIN a summary ON the inventory detail. 1 goods=1 summary. Goods) LEFT the JOIN into 1 summary ON inventory detail. Commodities=1 summary.
GROUP BY inventory detail. ID, inventory detail. Goods, inventory detail. Specifications, inventory detail. The original stock, into one summary. Storage aggregate, 1 summary. Outbound combined;

CodePudding user response:

Can be set to a condition as follows: the WHERE outbound combined ISNOTNULL