Querying the table based on a condition

[sureshchandra]

Hi,

I want to fetch records from a table 'A' based on a condition-
where A.field > B.field . B is another table.
What stage can be used to apply this filter.

Thanks in Advance

[ArndW]

If A and B are in the same schema, I would do it in the original SQL where you select your records. That would be the fastest, most efficient method.

[chulett]

Wouldn't even have to be in the same schema, the same database would do. Heck, doesn't even need to be that.

[hamzaqk]

use the odbc stage..

create a dummy seq file with a dummy column which reads data from a dummy file with any value just to create an input link to the odbc stage.

seq file ----> odbc

in the odbc stage , choose user defined sql and u r ready to rock and roll !

[ray.wurlod]

Just add the appropriate WHERE clause to the link properties in your database stage - probably on a tab called Selection.