I have a question regarding AMPScript. My Data Extensions are attached in the link at end of this question(For reference). I want to send personalised email adding product name.
%%[ var @productname set @productname = lookup("Products","product_name","product_id",[product_id]) ]%% <h1> You just purchased : %%= v(@productname) =%%
Please can someone correct me ?
Also, should I link these tables in Data designer ??? : https://i.stack.imgur.com/Fmq1p.png