Hello,
I want to do something like that:
SELECT t10.name
FROM schema2.person t10 INNER JOIN personInGroup t11 ON t11.ID =
t10.group_ID
WHERE t11.ID LIKE 'C12'
Where the person table in in another schema where I have the "SELECT"
rights. And I cannot get it to work. I could use a view, but it should
be possible without. I have seen in DBDatabase the setSchema, but it
looks global. I was expecting a way to define that in the table
definition (something like public tableName(DBDatabase theDB){
super("nameOfTable","nameOfSchema",theDB);), but it does not look
possible. So I guess I am totally in the wrong here :)
Also, I asked some time ago another simple questions, maybe the answers
should be added in the wiki? I could actually do a part of it if you'd
like (EmpireDB for dummies :) ).
Thank for your help,
Alain
