First create the index you want to use, then right click on the table name in the "Table Joins" window and click "Change Index". You will get error message.
Pick your single field index and you will be able to accomplish selecting the distinct values for a single field without selecting the entire primary key.
Source:JDELIST
No comments:
Post a Comment