CodeIgniter 4 Query Builder union() and unionAll() methods

<code>UNION</code> and <code>UNION ALL</code> set operators return the combined rows from 1 or more <code>SELECT</code> queries. CodeIgniter 4 Query Builder now supports <code>UNION</code> and <code>UNION ALL</code> queries with the <code>$builder->union()</code> and <code>$builder->unionAll()</code> methods respectively. Learn how to create these types of queries in this article. This article and many to follow, are part of a series of articles I am writing and sharing as I learn new concepts when I learn them. I think of it as a duty in sharing the things I learn as a self-taught developer. We all need to support one another as we continue to learn and grow. #buildinpublic #learninpublic #indiehackers #developer <h2>The Newsletter for PHP and MySQL Developers</h2> Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you <a href="http://openlamptech.substack.com/" rel="noopener ugc nofollow" target="_blank">subscribe to the OpenLampTech newsletter</a>. <h2>Data setup and housekeeping</h2> I’m using 2 simple tables with minimal data for the example queries, a customer and employee table: <img alt="" src="https://miro.medium.com/v2/resize:fit:378/0*XgUprZb5kz7GNhOF" style="height:215px; width:420px" /> Sample employee table data <img alt="" src="https://miro.medium.com/v2/resize:fit:385/0*efvyzOW2PNTFIuqq" style="height:202px; width:428px" /> Sample customer table data I also have these 2 protected properties in the Model class I am working with: <pre> protected $db; protected $builder;</pre> I’ll be logging (not shown) all of the executed queries using the <code>$db->getLastQuery()</code> method. I have <a href="https://levelup.gitconnected.com/codeigniter-4-query-helper-db-getlastquery-method-for-sql-prototyping-b8c7d78f18a1?sk=df1ec71ed16aef4d74435eb8e8e017af" rel="noopener ugc nofollow" target="_blank">written in-depth about </a><code><a href="https://levelup.gitconnected.com/codeigniter-4-query-helper-db-getlastquery-method-for-sql-prototyping-b8c7d78f18a1?sk=df1ec71ed16aef4d74435eb8e8e017af" rel="noopener ugc nofollow" target="_blank">$db->getLastQuery()</a></code> in the past so I won’t go into any details about it here. <h2>CodeIgniter 4 Query Builder $builder->union() method</h2> Perhaps one of the classic database practice questions with these 2 tables could be a requirement of: “Show me all the employees and customers in a single table.” We can absolutely do that with a <code>UNION</code> by using the <code>$builder->union()</code> method. <a href="https://levelup.gitconnected.com/codeigniter-4-query-builder-union-and-unionall-methods-de00668e785c">Click Here</a>