Joining with EcoResProductTranslation

Pay attention when joining with this table. It will multiply your rows because it keeps Description and Name for your products in as many languages as you have defined in your system.

In my case, i had to join InventTable with it, in order to get the name of the product. This is the join relation:

And i have restricted the language to only the current one:

 

Set the range on the EcoResProductTranslation table and choose the value of LanguageId as follows: