>Dear all,
>
> I have a table (Name, cost, code1, code2), I want to index it 1st in the code1 then at code2. For example, if it has:
>DDD $10 2 1
>AAA $20 2 4
>BBB $30 1 1
>CCC $20 1 2
>After indexing, I want to have the following showing in a Report:
>BBB $30 1 1
>CCC $20 1 2
>DDD $10 2 1
>AAA $20 2 4
>I tried ---
>index on code to table2
>index on code2 to table3
>set index to table2, table3
>But it does not work. Please tell me why or suggest a better way to do that.
>Thanks
How about INDEX ON code1+code2 TAG code?
HTH,
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!