{"id":461,"date":"2023-06-21T06:37:03","date_gmt":"2023-06-21T06:37:03","guid":{"rendered":"https:\/\/www.devopsconsulting.in\/blog\/?p=461"},"modified":"2023-06-21T06:37:04","modified_gmt":"2023-06-21T06:37:04","slug":"how-to-use-join-of-two-tables-in-laravel-query","status":"publish","type":"post","link":"https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/","title":{"rendered":"How to use join of two tables in Laravel query"},"content":{"rendered":"\n<p>In Laravel, joining tables is a common task when working with relational databases. Laravel provides a fluent query builder that allows you to perform database operations, including joins, in an expressive way.<\/p>\n\n\n\n<p>To join tables in Laravel, you can use the <code>join<\/code> method on the query builder instance. The <code>join<\/code> method accepts several arguments to define the join type and the tables involved in the join. Here&#8217;s an example of how you can perform a basic join in Laravel:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"615\" height=\"388\" src=\"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/06\/image-2.png\" alt=\"\" class=\"wp-image-462\" srcset=\"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/06\/image-2.png 615w, https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/06\/image-2-300x189.png 300w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>$users = DB::table('users')\n            -&gt;join('orders', 'users.id', '=', 'orders.user_id')\n            -&gt;select('users.*', 'orders.order_number')\n            -&gt;get();\n<\/code><\/pre>\n\n\n\n<p>In this example, we&#8217;re joining the &#8220;users&#8221; table with the &#8220;orders&#8221; table based on the &#8220;user_id&#8221; column. We&#8217;re selecting all columns from the &#8220;users&#8221; table and the &#8220;order_date&#8221; column from the &#8220;orders&#8221; table.<\/p>\n\n\n\n<p>You can specify the join type by using methods such as join, leftJoin, rightJoin, or crossJoin, depending on your requirements.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">leftJoin<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"669\" height=\"191\" src=\"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/06\/image-3.png\" alt=\"\" class=\"wp-image-463\" srcset=\"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/06\/image-3.png 669w, https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/06\/image-3-300x86.png 300w\" sizes=\"auto, (max-width: 669px) 100vw, 669px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>$users = DB::table('users')\r\n            ->join('orders', 'users.id', '=', 'orders.user_id')\r\n            ->join('payments', 'orders.id', '=', 'payments.order_id')\r\n            ->select('users.name', 'orders.order_date', 'payments.amount')\r\n            ->get();\n\r<\/code><\/pre>\n\n\n\n<p>In this case, we&#8217;re joining the &#8220;users&#8221; table with the &#8220;orders&#8221; table based on the &#8220;user_id&#8221; column and then joining the &#8220;payments&#8221; table with the &#8220;orders&#8221; table based on the &#8220;order_id&#8221; column. We&#8217;re selecting the user&#8217;s name, order date, and payment amount.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Laravel, joining tables is a common task when working with relational databases. Laravel provides a fluent query builder that allows you to perform database operations, including&#8230; <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[87],"tags":[],"class_list":["post-461","post","type-post","status-publish","format-standard","hentry","category-laravel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to use join of two tables in Laravel query - DevOps Consulting<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use join of two tables in Laravel query - DevOps Consulting\" \/>\n<meta property=\"og:description\" content=\"In Laravel, joining tables is a common task when working with relational databases. Laravel provides a fluent query builder that allows you to perform database operations, including...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/\" \/>\n<meta property=\"og:site_name\" content=\"DevOps Consulting\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-21T06:37:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-21T06:37:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/06\/image-2.png\" \/>\n<meta name=\"author\" content=\"Abhishek Singh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Abhishek Singh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-use-join-of-two-tables-in-laravel-query\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-use-join-of-two-tables-in-laravel-query\\\/\"},\"author\":{\"name\":\"Abhishek Singh\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\"},\"headline\":\"How to use join of two tables in Laravel query\",\"datePublished\":\"2023-06-21T06:37:03+00:00\",\"dateModified\":\"2023-06-21T06:37:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-use-join-of-two-tables-in-laravel-query\\\/\"},\"wordCount\":193,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-use-join-of-two-tables-in-laravel-query\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/image-2.png\",\"articleSection\":[\"Laravel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-use-join-of-two-tables-in-laravel-query\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-use-join-of-two-tables-in-laravel-query\\\/\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-use-join-of-two-tables-in-laravel-query\\\/\",\"name\":\"How to use join of two tables in Laravel query - DevOps Consulting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-use-join-of-two-tables-in-laravel-query\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-use-join-of-two-tables-in-laravel-query\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/image-2.png\",\"datePublished\":\"2023-06-21T06:37:03+00:00\",\"dateModified\":\"2023-06-21T06:37:04+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-use-join-of-two-tables-in-laravel-query\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-use-join-of-two-tables-in-laravel-query\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/image-2.png\",\"contentUrl\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/image-2.png\",\"width\":615,\"height\":388},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/\",\"name\":\"DevOps Consulting\",\"description\":\"DevOps Consulting | SRE Consulting | DevSecOps Consulting | MLOps Consulting\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\",\"name\":\"Abhishek Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"caption\":\"Abhishek Singh\"},\"description\":\"I\u2019m Abhishek, a DevOps, SRE, DevSecOps, and Cloud expert with a passion for sharing knowledge and real-world experiences. I\u2019ve had the opportunity to work with Cotocus and continue to contribute to multiple platforms where I share insights across different domains: \u2022 DevOps School \u2013 Tech blogs and tutorials \u2022 Holiday Landmark \u2013 Travel stories and guides \u2022 Stocks Mantra \u2013 Stock market strategies and tips \u2022 My Medic Plus \u2013 Health and fitness guidance \u2022 TrueReviewNow \u2013 Honest product reviews \u2022 Wizbrand \u2013 SEO and digital tools for businesses I\u2019m also exploring the fascinating world of Quantum Computing.\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/author\\\/abhishek\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to use join of two tables in Laravel query - DevOps Consulting","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/","og_locale":"en_US","og_type":"article","og_title":"How to use join of two tables in Laravel query - DevOps Consulting","og_description":"In Laravel, joining tables is a common task when working with relational databases. Laravel provides a fluent query builder that allows you to perform database operations, including...","og_url":"https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/","og_site_name":"DevOps Consulting","article_published_time":"2023-06-21T06:37:03+00:00","article_modified_time":"2023-06-21T06:37:04+00:00","og_image":[{"url":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/06\/image-2.png","type":"","width":"","height":""}],"author":"Abhishek Singh","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Abhishek Singh","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/#article","isPartOf":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/"},"author":{"name":"Abhishek Singh","@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f"},"headline":"How to use join of two tables in Laravel query","datePublished":"2023-06-21T06:37:03+00:00","dateModified":"2023-06-21T06:37:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/"},"wordCount":193,"commentCount":1,"image":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/#primaryimage"},"thumbnailUrl":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/06\/image-2.png","articleSection":["Laravel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/","url":"https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/","name":"How to use join of two tables in Laravel query - DevOps Consulting","isPartOf":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/#primaryimage"},"image":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/#primaryimage"},"thumbnailUrl":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/06\/image-2.png","datePublished":"2023-06-21T06:37:03+00:00","dateModified":"2023-06-21T06:37:04+00:00","author":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-use-join-of-two-tables-in-laravel-query\/#primaryimage","url":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/06\/image-2.png","contentUrl":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/06\/image-2.png","width":615,"height":388},{"@type":"WebSite","@id":"https:\/\/www.devopsconsulting.in\/blog\/#website","url":"https:\/\/www.devopsconsulting.in\/blog\/","name":"DevOps Consulting","description":"DevOps Consulting | SRE Consulting | DevSecOps Consulting | MLOps Consulting","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.devopsconsulting.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f","name":"Abhishek Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","caption":"Abhishek Singh"},"description":"I\u2019m Abhishek, a DevOps, SRE, DevSecOps, and Cloud expert with a passion for sharing knowledge and real-world experiences. I\u2019ve had the opportunity to work with Cotocus and continue to contribute to multiple platforms where I share insights across different domains: \u2022 DevOps School \u2013 Tech blogs and tutorials \u2022 Holiday Landmark \u2013 Travel stories and guides \u2022 Stocks Mantra \u2013 Stock market strategies and tips \u2022 My Medic Plus \u2013 Health and fitness guidance \u2022 TrueReviewNow \u2013 Honest product reviews \u2022 Wizbrand \u2013 SEO and digital tools for businesses I\u2019m also exploring the fascinating world of Quantum Computing.","url":"https:\/\/www.devopsconsulting.in\/blog\/author\/abhishek\/"}]}},"_links":{"self":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/comments?post=461"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/461\/revisions"}],"predecessor-version":[{"id":464,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/461\/revisions\/464"}],"wp:attachment":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/media?parent=461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/categories?post=461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/tags?post=461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}