# Cakephp 3.1.3 - Joining data across multiple tables..?

**URL:** https://discourse.cakephp.org/t/cakephp-3-1-3-joining-data-across-multiple-tables/4716
**Category:** Need Help
**Created:** [August 14, 2018, 5:38am UTC](https://discourse.cakephp.org/t/cakephp-3-1-3-joining-data-across-multiple-tables/4716 "2018-08-14T05:38:11Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![dash](https://avatars.discourse-cdn.com/v4/letter/d/7c8e57/32.png) [@dash](https://discourse.cakephp.org/u/dash)
#### Post date: [August 14, 2018, 5:38am UTC](https://discourse.cakephp.org/t/cakephp-3-1-3-joining-data-across-multiple-tables/4716/1 "2018-08-14T05:38:11Z")

</div>

**this is my php code**

$sqla = “SELECT \* FROM `users` INNER JOIN registration ON users.id=registration.id WHERE users.id=‘1’”;  
$resa = mysqli\_query($conn, $sqla) or die(“Query not execute” . mysql\_error());

while($rowa = mysqli\_fetch\_array($resa))  
{  
$name = $rowa[‘name’]);  
$name = $rowa[‘email’]);  
}

**In that above code how to write in cakephp 3.1.3 …?**

please help me.

thanks & regards,  
Darshan

---

<div class="post-metadata">

### Author: ![rrd](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/rrd/32/113_2.png) [@rrd](https://discourse.cakephp.org/u/rrd)
#### Post date: [August 14, 2018, 1:26pm UTC](https://discourse.cakephp.org/t/cakephp-3-1-3-joining-data-across-multiple-tables/4716/2 "2018-08-14T13:26:55Z")

</div>

You should associate the two models.  
[https://book.cakephp.org/3.0/en/orm/associations.html](https://book.cakephp.org/3.0/en/orm/associations.html)

Than use the query builder’s `contain()` method  
[https://book.cakephp.org/3.0/en/orm/query-builder.html#loading-associations](https://book.cakephp.org/3.0/en/orm/query-builder.html#loading-associations)