Index table query structure

2005-04-14 Thread Yemi Obembe
If for example I have a table with the 3 columns: name,age,sex I build an index table on the column 'name'. how can i get result of the other rows (i.e age and) from the main table if i 'select' a name from the main table? In short, what is the structure(or should i say syntax?) of a

Index table query structure

2005-04-14 Thread Yemi Obembe
If for example I have a table with the 3 columns: name,age,sex I build an index table on the column 'name'. how can i get result of the other rows (i.e age and) from the main table if i 'select' a name from the main table? In short, what is the structure(or should i say syntax?) of a

Re: Index table query structure

2005-04-14 Thread Roger Baklund
Yemi Obembe wrote: If for example I have a table with the 3 columns: name,age,sex I build an index table index table ? There is no such thing. on the column 'name'. how can i get result of the other rows (i.e age and) other rows? You mean other columns? from the main table What main table?