MySQL Forums
Forum List  »  Newbie

Query Language Translation Tables
Posted by: Nathan Hastings
Date: April 29, 2017 09:11AM

I am attempting to query a table that has to foreign keys (i.e. VendorID and ProductID). In the related tables, there is a localizationID that corresponds to a longtext value in the language translation tables. So the longtext of the vendorname and the longtext of the productname is stored in the language translation table, due to this RDBS being an international application. I need to pass the values to separate variables to create a column for the vendorname and productname. I am joining on the VendorID and ProductID to the related tables to obtain the localizationID for both. Any thoughts would be appreciated.

Options: ReplyQuote


Subject
Written By
Posted
Query Language Translation Tables
April 29, 2017 09:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.