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,

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 dDa

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 dDat