![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_1_5-1.png\")
<\/a><\/p>\nThen select the required columns:<\/p>\n
Note that if at least one table has been added to the\u00a0\u201cDiagram\u201d\u00a0pane, the\u00a0\u201cTables\u201d\u00a0pane highlights tables that have a relationship with any of the recently added tables:<\/p>\n To join the already added table with an another table, do one of the following:<\/p>\n After that, \u201cQuery Builder\u201d displays a relationship between tables:<\/p>\n If necessary, the relation between the tables can be edited. To do this, right-click on the required relation and select \u201cEdit Relation\u201d from the context menu:<\/p>\n As a result, the following window appears:<\/p>\n Join type \u2013 type of relation.<\/p>\n The following types of relation are available in the drop-down list:<\/p>\n Next, in the drop-down list, select the name for the data binding:<\/p>\n If needed, relation with a table can be deleted:<\/p>\n<\/a><\/p>\n<\/a><\/p>\n\n
<\/a> next to the foreign key column (\u201cProductSubcategoryKey\u201d in the image above);<\/li>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n\n
<\/a><\/p>\n