Hi,
I've only started writing in SQL recently and I was trying to join the two queries I made below into one table
-- Outbounds Part 1
SELECT
WWL.Barcode AS "Location",
COUNT(DISTINCT WWA.PalletId) AS "#Pallets Due"
FROM
Warehouse.WarehouseNotes AS WWN
INNER JOIN Warehouse.WarehouseActions WWA ON WWA.WarehouseNoteId = WWN.Id
INNER JOIN Warehouse.WarehouseLocations WWL ON WWA.RequestedLocationId = WWL.Id
WHERE
(WWL.Barcode LIKE '%BU%' OR WWL.Barcode LIKE '%LB%') AND WWA.PalletId IS NOT NULL
AND (WWN.NoteType = 1 AND (WWA.ActionStatus = 1 OR WWA.ActionStatus = 2))
GROUP BY
WWL.Barcode
ORDER BY
"Location"
-- Outbounds Part 2
SELECT
WWL.Barcode AS "Location",
COUNT(DISTINCT WWA.PalletId) AS "#Pallets Current"
FROM
Warehouse.WarehouseNotes AS WWN
INNER JOIN Warehouse.WarehouseActions WWA ON WWA.WarehouseNoteId = WWN.Id
INNER JOIN Warehouse.WarehouseLocations WWL ON WWA.RequestedLocationId = WWL.Id
WHERE
(WWL.Barcode LIKE '%BU%' OR WWL.Barcode LIKE '%LB%') AND WWA.PalletId IS NOT NULL
AND (
(WWN.NoteType = 6 AND (WWN.NoteStatus = 1 OR WWN.NoteStatus = 2)) OR (WWN.NoteType = 1 AND(WWN.NoteStatus = 2 AND WWA.ActionStatus = 3))
)
GROUP BY
WWL.Barcode
ORDER BY
"Location"
Any help would be greatly appreciated!