using birt 2.2 - <br />
in our data sets, we have to qualify:<br />
select DB_NAME.TABLE_NAME.FIELD_NAME <br />
from DB_NAME.TABLE_NAME <br />
etc.<br />
does anyone know how to select fields from a database link (we're using oracle 10).<br />
in sql plus it would be select * from linked_table@MYLINK<br />
but this does not work in birt (table does not exist):<br />
select db.table1.field1, <br />
<a href='mailto:' title='E-mail Link' class='bbc_email'>db.linked_table@mylink.fiel</a>d2<br />
from db.table, db.linked_table@mylink<br />
--- nor does: <br />
select mylink.linked_table.field2 from my_link.linked_table;
