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