Topic: Querying two different values using table relationship
Hi everybody,
I know how to perform what I am looking for using a SQL Query but I wonder if there would be an easier way to do it using only MVDB internal engine.
In one of my project, I have a table which must contain 2 columns with different values but using a "dictionary table" to avoid data redundancy and I would like to display the value instead of the "id" in my query (see attached picture).
For instance, my table "Ports" has id_VLANS and id_VLANS1 referring both to table VLAN but I cannot figure out how to display the proper VLAN_ID for each using default tools. To do so, I would need a "join" feature in the properties...
The idea is to display only the VLAN_ID for id_VLANs and id_VLANS1.
This project is developed using 2.03 alpha.