Hi Denis,

You could use a view:

create sql view plantsByName ;
    as select a.*, b.name ;
    from plants a ;
    join plantNames b on (a.nameID = b.nameID) ;
    order by b.name
use plantsByName

>I have a Table A with a list of plants, each of which has a species name. The species name list is held in Table B. Table A has a numeric code relating to Table B. Table B is indexed on this numeric code to facilitate the relationship. All of this ... the most basic relationship between two tables.
>
>However, I want to list Table A sorted A-Z by species? Clearly, if I switch the Table B index to the species names sorted AZ, the relationship to A is lost. My work around for now is to include a (redundant)short species name field in Table A and to index on this. It works - but can't be the correct way.