|
|
Choose a letter above to display Genera SELECT DISTINCT `LEP_hodglst`.`Genus` FROM LEP_inputsum LEFT JOIN `LEP_hodglst` ON `LEP_inputsum`.`Hodgesno` = `LEP_hodglst`.`Hodgesno` WHERE ( ( `LEP_hodglst`.`Genus` LIKE 'Y%' ) AND ( `LEP_inputsum`.`Cllctncode` = 'ISMQ' ) ) ORDER BY `LEP_hodglst`.`Genus` ASC |
|