Hi,
I am writing a sql ovrride in informatica tool.
I need to write a query which extracts the data of today and yesterday's data from a table.

select today,today-1 from tfct_cllg_inmcg;

in clear terms actually I require a particular day data and previous day data
like the following query.

select date,date-1 from tfct_cllg_incmg.

Could you please help me in getting the sql query.

you could send me the query to mandla.srinivas@gmail.com

values current date

1
----------
01/05/2007

values current date - 1 day

1
----------
01/04/2007