I need to execute the following query to bring in my source:
select * from tbl1 where btch_id = select max(btch_id) from tbl2
How can I do this efficiently using Relational Stage?
Also, is there a more efficient way of joining > 2 tables without using Lookup Stages after the initial Join Stage?
This topic has been locked.
1 reply Latest Post - 2004-10-26T10:20:19Z by SystemAdmin
Pinned topic Query SubSelect and Multi Table Join
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2004-10-26T10:20:19Z at 2004-10-26T10:20:19Z by SystemAdmin