Grouping the Index values by using common field

Hy guys,

     My indexes are =>

                                index1=> eid,name,age
                                index2=>eid,company,address

  Now i am combine these two indexes by creating index as index*

but, i need a data table like below,

   eid      name       age     company      address

   101     rob          22        gu         CA
   102     bob          21        hu         SA

but i am getting is null , i can't set a eid as a primary key and can't group the combined index values.

Help me about this, THANK YOU in Advance :wink:

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.