New answers tagged union
I'm not sure why you are using subqueries in the upper SELECT of the union. I rewrote your query without the subquery and duplicated the upper and lower SELECTs of the union. Only then changing the interval on the bottom SELECT to 30. SELECT sd.StockNumber AS StkNm, sd.Description As Descr, sd.Location As Loc, SUM(sd.QtyShipped) AS d3q, ...
Top 50 recent answers are included