CREATE INDEX IN SQL

[KUZZ]

The following expression is good when I want one primary index:

CREATE INDEX idxPT ON tbl_PRIO_UCA([PT#])With PRIMARY;

what would the syntax be on creating a double index on the table, one for field PT# and another one for field REV
Good luck,
Kuzz

"Time spent debating the impossible subtracts from the time during which you
can try to accomplish it."

 

[KUZZ]

Got is myself

CREATE INDEX idxPT ON tbl_PRIO_UCA([PT#],[REV]) With PRIMARY;
Good luck,
Kuzz

"Time spent debating the impossible subtracts from the time during which you
can try to accomplish it."