Newbie help with joining 2 tables

[#1]

I would like to join these 2 tables below on date and currency.

I did a cast on time since it was a datetime field and just picked up first 10 characters.

Im sorry first time doing joins but how is it done in Qlikview? I can do it in SQL but when it comes to qlikview I have no idea?

Execution:

LOAD

     last_liquidity,

     time,

    Left(timestamp(time, 'YYYY-MM-DD hh:mm:ss'),10)                as date,

     routing_instruction,

     Turnover,

     flag_Fills,

     account_ref,

     last_liquidity_ind,

     algo_id,

     client_id,

     client_order_id,

     currency,

     destination,

     exec_broker,

     exec_id,

     exec_type,

FROM

(qvd);

Left join(Execution)

LOAD

    date,

     currency,

     rate_eur

FROM

(qvd);

[Chanty4u]

did u try 

Noconcatenate (Execution)

[#3]

instead of left join? gives me wrong syntax

[sivarajs]

Qlikview default joins the column matching between the tables. If more than a column matches , it creates a synthetic key. You can avoid by aliasing any column ( A as AA).

[robert_mika · Accepted solution]

Execution:

LOAD

     last_liquidity,

     time,

  currency &'-'& Left(timestamp(time, 'YYYY-MM-DD hh:mm:ss'),10) as %Key

    Left(timestamp(time, 'YYYY-MM-DD hh:mm:ss'),10)                as date,

     routing_instruction,

     Turnover,

     flag_Fills,

     account_ref,

     last_liquidity_ind,

     algo_id,

     client_id,

     client_order_id,

     currency,

     destination,

     exec_broker,

     exec_id,

     exec_type,

FROM

(qvd);

Left join(Execution)

LOAD

date&'-'& currency as &Key

       rate_eur

FROM

(qvd);

[#6]

Thank you