The documentation for t<DB flavor>Input state that the schema of those components must exactly match the schema of the table they represent, so the most you can do in the SQL is filter out items. If you want to do a join, then as Robert said, use two tOracleInput components, and either a tJoin (which does not seem to generate valid Java unless you include all fields of both tables in the resulting output) or a tMap to merge them together. There is also a tELT<DB flavor>Map, which apparently generates SQL and uses the DB to do all the work, instead of generating Java. However, I have not used it yet, so your mileage may vary.