Join by dates

[ester_pr]

Hi,

I want to join tables

on table have costNamber, cost and date_of_updatd

and the oter have costNamber and date_of_debit,

of cuorse the cost shuold be attached to the cost of the date that in between the date_of_updatdes

how to do it when ther is one field of date?

is it better to do so in a script or in the object?

Thank you,

Ester

[rohit214]

tab1:

load

costNamber as costNamber_tab1,

cost ,

date((date_of_updatd),'DD/MM/YYYY')  as common_date

;

tab2:

load

costNamber as costNamber_tab2,

date( date_of_debit),'DD/MM/YYYY) as common_date

;

i hope  u understand .

Thanx and Regard

rohit