Hi Paul,

I worked on the IBM AS/400 system for years. When I created a file and built key fields, the default was unique keys. You could override that and say...

I would like a key or index on employee and transaction date. However, the data is not unique, so I can't make them primary keys. If SQL could have non...

Thanks Sean.

Lets say I just create a non unique index on employee and date with no primary keys defined. When I write queries or programs for the users to extract...