You should use the same datasource for all the entities involved in the query. And you can't select fields in the finder, you must use ejbSelect instead.
the reason for using multiple datasources is because the tables are in seperate schemas, and due to security restrictions, they must have different user names to access them. If i can do this in a single datasouce, please let me know.
I will change it to an ejbSelect instead of an ejbFind, but won't this mean that i will have to have an object of type ContentFile to be able to call the select ??? I am trying to find a record of type ContentFile that represents the query.