Minus in View?

Hey, there,
I was trying to create a view to get the new customer# fro year 2005 using the following code:
CREATE OR REPLACE VIEW NewCustomers
AS
SELECT Customer# FROM tblOrderFact
WHERE TransDate BETWEEN '20050101' AND '20051231' MINUS
SELECT Customer# FROM tblOrderFact
WHERE TransDate < '20050101'

The error message told me that MINUS was not allowed in updateble views. Can anyone give me suggestions?
Thanks.
Xiaolu Received on Wed Sep 28 2005 - 16:32:13 CDT