|
|
Dragonfly & Damselfly Database
SELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'A%' and `Odon`.`State` = 'IL' order by Genus|ASELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'B%' and `Odon`.`State` = 'IL' order by Genus|BSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'C%' and `Odon`.`State` = 'IL' order by Genus|CSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'D%' and `Odon`.`State` = 'IL' order by Genus|DSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'E%' and `Odon`.`State` = 'IL' order by Genus|ESELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'F%' and `Odon`.`State` = 'IL' order by Genus|FSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'G%' and `Odon`.`State` = 'IL' order by Genus|GSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'H%' and `Odon`.`State` = 'IL' order by Genus|HSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'I%' and `Odon`.`State` = 'IL' order by Genus|ISELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'J%' and `Odon`.`State` = 'IL' order by Genus|JSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'K%' and `Odon`.`State` = 'IL' order by Genus|KSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'L%' and `Odon`.`State` = 'IL' order by Genus|LSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'M%' and `Odon`.`State` = 'IL' order by Genus|MSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'N%' and `Odon`.`State` = 'IL' order by Genus|NSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'O%' and `Odon`.`State` = 'IL' order by Genus|OSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'P%' and `Odon`.`State` = 'IL' order by Genus|PSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'Q%' and `Odon`.`State` = 'IL' order by Genus|QSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'R%' and `Odon`.`State` = 'IL' order by Genus|RSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'S%' and `Odon`.`State` = 'IL' order by Genus|SSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'T%' and `Odon`.`State` = 'IL' order by Genus|TSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'U%' and `Odon`.`State` = 'IL' order by Genus|USELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'V%' and `Odon`.`State` = 'IL' order by Genus|VSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'W%' and `Odon`.`State` = 'IL' order by Genus|WSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'X%' and `Odon`.`State` = 'IL' order by Genus|XSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'Y%' and `Odon`.`State` = 'IL' order by Genus|YSELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'Z%' and `Odon`.`State` = 'IL' order by Genus|Z|
Choose a letter above to display Taxa
SELECT DISTINCT `Odon`.`Genus`, `Odon`.`Species` FROM `Odon` WHERE `Odon`.Genus LIKE 'S%' and `Odon`.`State` = 'IL' order by Genus
|
