var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Combining 2 SELECT statments
i have two select statements that i need combined into one to display the proper formated data
1) SELECT * FROM sales WHERE Statues = 'Open' or Statues = 'Hold' ORDER BY Date,OrderNum
2) SELECT OrderNum, count( * ) AS Titems
GROUP BY OrderNum
how would i go about combining the query?
SELECT Date,OrderNum, count( * ) AS Titems
WHERE Statues = 'Open' or Statues = 'Hold'
GROUP BY Date,OrderNum
ORDER BY Date,OrderNum
Is that what you mean?
yup, that is what i was looking for, thanks.