what about:
CREATE UNIQUE INDEX id ON thistable (APPCODE, EMAILID);
regards,
rene
- Original Message -
From: "Duke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 4:02 PM
Subject: Wats the CREATE TABLE statement?
I would like to k
I would like to know how to write a SQL statement if i have a composite key
present in the table. eg. my table is
APPCODE EMAILID EMAIL
1 ML1 [EMAIL PROTECTED]
1 ML2 [EMAIL PROTECTED]
2 ML1 [EMAIL PROTECTED]
3 ML1 [EMAIL PROTECTED]
4 ML1 [EMAIL PR