Hi,
I'm running biomart for uniprot at:
http://sbornia.windows.ebi.ac.uk:9002/biomart/martview/
When you select Keyword as a filter (say "Complete Proteome") and count,
it's correct. When you select the results (without the keyword) it's
correct, but ty the time you actually select to see the keywords (in the
attributes) I get this weird SQL:
SELECT main.name_1039, renato1.UNIPROT__KEYWORD__DM.keyword_1088
FROM renato1.UNIPROT__KEYWORD__DM, renato1.UNIPROT__KEYWORD__dm,
renato1.UNIPROT__ENTRY__MAIN main
WHERE (UNIPROT__KEYWORD__dm.keyword_1088 = 'Complete proteome')
AND
main.dbentry_id_1039_key=renato1.UNIPROT__KEYWORD__DM.dbentry_id_1039_key
AND main.dbentry_id_1039_key=<*>UNIPROT__KEYWORD__dm.dbentry_id_1039_key
AND rowNum < 201
Note that the table "renato1.UNIPROT__KEYWORD__DM" appears twice on the
FROM and the match
"dbentry_id_1039_key=UNIPROT__KEYWORD__dm.dbentry_id_1039_key" appears
twice on the WHERE clause.
With that, I receive an "ORA-00918: column ambiguously defined" error.
I've removed the duplicates and the query runs fine. Is there something
I'm doing wrong?
cheers,
--renato
--
Reclaim your digital rights, eliminate DRM, learn more at
http://www.defectivebydesign.org/what_is_drm
