You’re offline. This is a read only version of the page.
Am trying to link EcoREs Product Translation table with the items...How can I do this? I have tried using this table and using the Rec ID and cross referencing it with the rec ID in the Eco Res Product and Product Master table but cannot get the correct match.....
*This post is locked for comments
I have the same question (0)
EcoResProductTranslation can be joined directly to InventTable as follows.
where ecoResProductTranslation.Product == inventTable.Product
You may want to add LanguageId to your where clause, if you have multiple translations and are interesting in just showing one.
Of course if you're doing this in SQL, don't forget to join on [PARTITION] also.
Share
Report
All responses (
Answers (
17,788
