Help with CREATE SELECT Statement

2004-02-11 Thread Carlos Vazquez
I get this error when I try to execute the following select statement: All Parts of a PRIMARY KEY must be NOT NULL; if you need null in a key, use UNIQUE instead. CREATE TEMPORARY TABLE IF NOT EXISTS CashVariances (PRIMARY KEY(sUnit)) SELECT sUnit, dSalesDate AS

Help with CREATE SELECT Statement

2004-02-11 Thread Carlos Vazquez
I get this error when I try to execute the following select statement: All Parts of a PRIMARY KEY must be NOT NULL; if you need null in a key, use UNIQUE instead. CREATE TEMPORARY TABLE IF NOT EXISTS CashVariances (PRIMARY KEY(sUnit)) SELECT sUnit, dSalesDate AS

Re: Help with CREATE SELECT Statement

2004-02-11 Thread Roger Baklund
* Carlos Vazquez I get this error when I try to execute the following select statement: All Parts of a PRIMARY KEY must be NOT NULL; if you need null in a key, use UNIQUE instead. CREATE TEMPORARY TABLE IF NOT EXISTS CashVariances (PRIMARY KEY(sUnit)) SELECT sUnit,