{"id":153,"date":"2022-06-09T18:31:49","date_gmt":"2022-06-09T18:31:49","guid":{"rendered":"https:\/\/docs.xlreport.com\/?post_type=docs&#038;p=153"},"modified":"2022-06-12T16:21:11","modified_gmt":"2022-06-12T16:21:11","slug":"joins-relationships","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/add-tables-to-the-query\/joins-relationships\/","title":{"rendered":"Joins &#8211; Relationships"},"content":{"rendered":"<h2>Automatics Joins<\/h2>\n<p>XLReport will add relationship joins automatically if detected in your database schema.<\/p>\n<ul>\n<li value=\"1\">You can edit the relationship joins or add them manually.<\/li>\n<\/ul>\n<h2>Create Joins manually<\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/18.png\" \/><\/p>\n<ul>\n<li value=\"1\">Select the field to join from one table and drag it to the field to join of the another table.<\/li>\n<\/ul>\n<p>This will create an INNER join.<\/p>\n<h2>Edit Joins<\/h2>\n<ul>\n<li value=\"1\">Double click the join line.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/19.png\" \/><\/p>\n<ul>\n<li value=\"1\">Choose between LEFT, RIGHT and INNER joins.<\/li>\n<\/ul>\n<h2>Remove Joins<\/h2>\n<ul>\n<li value=\"1\">To remove a join select the join line, right click and select Remove .<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/20.png\" \/><\/p>\n","protected":false},"featured_media":0,"parent":151,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/153"}],"collection":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/comments?post=153"}],"version-history":[{"count":2,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/153\/revisions"}],"predecessor-version":[{"id":361,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/153\/revisions\/361"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/151"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=153"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}