Hi, Could anyone please explain why this error occured when I execute the following MQL query. Also please let me know how could I solve the problem. Thanks. -- Mamun
using Experiment get experiment_accession where ba_performer like q(%Novartis%) 15-Nov-2006 17:23:20 org.ensembl.mart.lib.AttributeQueryRunner executeQueryGeneric INFO: SQL : SELECT main.experiment_accession, main.EXPERIMENT_ID_KEY FROM aemart.ae1__assay_performer__dm ,aemart.AE1__EXPERIMENT__MAIN main WHERE main.EXPERIMENT_ID_KEY >= -1 AND aemart.ae1__assay_performer__dm .value like? AND main.ASSAY_ID_KEY =aemart.ae1__assay_performer__dm .ASSAY_ID_KEY ORDER BY main.EXPERIMENT_ID_KEY 15-Nov-2006 17:23:20 org.ensembl.mart.lib.AttributeQueryRunner executeQueryGeneric WARNING: ORA-00904: "MAIN"."ASSAY_ID_KEY": invalid identifier org.ensembl.mart.lib.InvalidQueryException: ORA-00904: "MAIN"."ASSAY_ID_KEY": invalid identifier
