ERROR 1064 (42000): WIth the following code claiming its at line 1

[osirion666]

CREATE TABLE Order

(

ONo CHAR(5) NOT NULL,

CNo CHAR(5) NOT NULL,

PNo CHAR(5) NOT NULL,                                                                                 

SNo CHAR(5),

Qty INTEGER UNSIGNED NOT NULL,

Date DATETIME,

PRIMARY Key(CNo, PNO, SNo)

FOREIGN KEY(CNo) REFERENCES Customer(CNo)

ON DELETE NO ACTION

ON UPDATE CASCADE,

FOREIGN KEY(PNo) REFERENCES Product(PNo)

ON DELETE NO ACTION

ON UPDATE CASCADE,

FOREIGN KEY(SNo) REFERENCES SalesRep(SNo)

ON DELETE No ACTION

ON UPDATE CASCADE

) Engine = InnoDB;

 

the full error code is as follows

"

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your

MySQL server version for the right syntax to use near 'Order"

 

I am new to this so would appreciate any help Thanks in advance

 

[Mchl]

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html