hOW CAN i IMPLEMENT A SQL 'BETWEEN' IN AN TRANSFORMATION
Posted: Wed Feb 15, 2006 7:26 am
Hi All,
I'm have 2 tables A: have person age
B: A certain id for age range.
meaning : Person with age value of 24 in table A
will mean in table B id : 3 start_age: 20, end_age: 25
so when I join these table in SQL and ask for the id the sql statement will look like this:
select b.id
from a,b
where a.age between b.start_age and b.end_age
how can implement the above in a transformation, I know I can try and use custom SQL, but is there a way to do it via the transformation it self
I'm have 2 tables A: have person age
B: A certain id for age range.
meaning : Person with age value of 24 in table A
will mean in table B id : 3 start_age: 20, end_age: 25
so when I join these table in SQL and ask for the id the sql statement will look like this:
select b.id
from a,b
where a.age between b.start_age and b.end_age
how can implement the above in a transformation, I know I can try and use custom SQL, but is there a way to do it via the transformation it self