For example emp1 and emp2 are two tables and some attributes of emp1 are to be used in emp2 with one primary key
So how can we join these 2 tables in bom.xml?
Submitted by Dibyajit.Roy on Sun, 07/25/2021 - 19:25
Hello
there are two ways to do this
1) You need to first create the child table. Define the attributes.
Then create the parent table. Inside the parent table, there is a option in the Attribute section where you can choose child table as an option. this will create the foreign key .
Going forward , you can use the attribute name to refer to child table from parent table.
2) You can use REST API to write your own query to fetch data based on JOIN SQL statement.
Comments
Hello
there are two ways to do this
1) You need to first create the child table. Define the attributes.
Then create the parent table. Inside the parent table, there is a option in the Attribute section where you can choose child table as an option. this will create the foreign key .
Going forward , you can use the attribute name to refer to child table from parent table.
2) You can use REST API to write your own query to fetch data based on JOIN SQL statement.
regards