Left join help

[mahitham]

Hi Experts,

Can any one please help me on below issue.

I have Two tables like below. Here I am doing left join with DATE field.

While doing left join I am getting -129 error its like timeout error. After refreshing the browser also getting same error.

When I do the outer join its loading, but I need to combine these two tables into one.

Please suggest me to combine these two tables into one instead of left join with apply map or any other way.

Table1:

Date(Date#(Date(Timestamp(Date),'DD/MM/YYYY'),'DD/MM/YYYY'),'DD/MM/YYYY') as DATE,

ID,

CURRENCY,

RATE,

VALUE

From ....      

left join(Table1)

Table2:

Date(Date#(Date(Timestamp(STARTDATE),'DD/MM/YYYY'),'DD/MM/YYYY'),'DD/MM/YYYY') as DATE,

FROM_CCY,

TO_CCY

From ....  

Thanks in advance

[passionate]

try joining by numeric value of date i.e num(Date)

[vishalarote]

Convert date first timestamp to actual

for e.g.

Date(Date#(timestamp#(Date,'DD/MM/YYYY hh:mm;ss'),'DD/MM/YYYY'),'DD/MM/YYYY') as Date

Date(Date#(timestamp#(STARTDATE,'DD/MM/YYYY hh:mm;ss'),'DD/MM/YYYY'),'DD/MM/YYYY') as Date

and then left join that two tables.