Adding three statements together, need help

[peels]

I am new at this and struggling, I have these three statements that work independently, but I need to put them all together into one so that I can get the output that I desire. I appreciate any help that anyone can give me.

SELECT uvb.item_number,
COUNT(uvb.item_number) as cases_scanned
FROM t_uv_barcode uvb
WHERE uvb.barcode_uom = 'CASE' AND uvb.barcode LIKE '%C'
GROUP BY uvb.item_number


SELECT uvb.item_number,
COUNT(uvb.barcode) as cases_sold
FROM t_uv_barcode uvb
WHERE uvb.barcode_uom = 'CASE'
GROUP BY uvb.item_number


SELECT uv.item_number,
SUM(uv.qty_needed) as units_sold, SUM(uv.qty_scanned) as units_scanned
FROM t_order o (NOLOCK)
INNER JOIN t_uv_barcode_listener uv (NOLOCK)
ON o.order_number = uv.order_number
GROUP BY uv.item_number
ORDER BY uv.item_number

 

[jbenson001]

Use UNION or UNION ALL to combine the results.

 

[Lamprey13]

Since you did not supply you desired output, I'm not sure what you want, but here is one option using UNION ALL as JBenson suggested:

SELECT
	item_number,
	SUM(cases_scanned),
	SUM(cases_sold),
	SUM(units_sold),
	SUM(units_scanned)
FROM
	(
		SELECT 
			uvb.item_number,
			COUNT(uvb.item_number) as cases_scanned,
			0 as cases_sold,
			0 as units_sold,
			0 as units_scanned
		FROM t_uv_barcode uvb
		WHERE uvb.barcode_uom = 'CASE' AND uvb.barcode LIKE '%C'
		GROUP BY uvb.item_number

		UNION ALL

		SELECT 
			uvb.item_number,
			0,
			COUNT(uvb.barcode) as cases_sold,
			0,
			0
		FROM t_uv_barcode uvb
		WHERE uvb.barcode_uom = 'CASE'
		GROUP BY uvb.item_number

		UNION ALL

		SELECT 
			uv.item_number,
			0,
			0,
			SUM(uv.qty_needed) as units_sold, 
			SUM(uv.qty_scanned) as units_scanned
		FROM t_order o (NOLOCK)
		INNER JOIN t_uv_barcode_listener uv (NOLOCK)
		ON o.order_number = uv.order_number
		GROUP BY  uv.item_number
	)
GROUP BY
	item_number