[net amount due],
convert(datetime,[hold reason 4])
[process week] BETWEEN '8/1/2012' AND '8/31/2012'
Pro IN (SELECT
[Process Week] BETWEEN '8/1/2012' AND '8/31/2012')
Good Day Experts!
I am in a bit of a quandry here. I have one query that returns 46,419 records and a second one that returns 49,004 records. I have the resulting data in seperate worksheets in Excel. Now I want to make a third worksheet to hold the 2,585 records that are in the second query not in the first one. So, I thought of the minus operator in SQL. Only problem is I get an error in SQL Query Analyzer when I try to do the minus. Erorr indicates--> Incorrect syntax near 'MINUS'.
I have never used minus before. Perhaps I have something wrong. Can you help?