Eclipse Community Forums: BIRT » BIRT Dataset Usage

Home » Archived » BIRT » BIRT Dataset Usage (Is it possible to pass entire dataset into the IN CLAUSE of another Data set)

Show: Today's Messages :: Show Polls :: Message Navigator

BIRT Dataset Usage [message #1243860]

Tue, 11 February 2014 14:50

ashwani tripathi

Messages: 1
Registered: February 2014

Junior Member

My requirement is to get the list of ids from one database suppose sybase and then I wish to pass this list of ids to another database for processing using NOT IN clause in the sql query.

For example: I have two separate database. I will get the records from one db in one data set and then pass the entire records to another data set.

select * from second_table where id not in (select id from first_database_table)

Report message to a moderator