Error in your query: select distinct name from diseases order by nameError in your query: select distinct name from geneError in your query: select phi_base_acc from geneError in your query: select distinct common_name from species,on_host where ncbi_tax_id=on_host.tax_id_fkError in your query: select distinct syst_name from species,from_pathogen where ncbi_tax_id=from_pathogen.tax_id_fk order by syst_nameError in your query: