Hello! This is only an idea: JasperETL is a transformation tool, You can make "joins" in a graphical way, not in sql. You need to add 2 datasources (tOracleInput). In the first, you can select one of the tables (select * from refs), and in the other you can select the other table (select * from Dlayout). After this, you can make a "joined" table with tMap component (tMap's inputs are the two tables above). You can select the required fields from the tables, and you can make a new output table. Robert