# How to write inner join in cakephp 3.6.7
**URL:** https://discourse.cakephp.org/t/how-to-write-inner-join-in-cakephp-3-6-7/4668
**Category:** Need Help
**Created:** [August 6, 2018, 7:46am UTC](https://discourse.cakephp.org/t/how-to-write-inner-join-in-cakephp-3-6-7/4668 "2018-08-06T07:46:28Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@dash](https://discourse.cakephp.org/u/dash)
#### Post date: [August 6, 2018, 7:46am UTC](https://discourse.cakephp.org/t/how-to-write-inner-join-in-cakephp-3-6-7/4668/1 "2018-08-06T07:46:28Z")
in core php we are using query like this:
**SELECT \* FROM `users` INNER JOIN registration ON users.id=registration.id WHERE users.id='7’**
how can write in **Cakephp 3.6.7**
thanks & regards,
Darshan
---
### Author:  [@Speudyland](https://discourse.cakephp.org/u/Speudyland)
#### Post date: [August 6, 2018, 8:04am UTC](https://discourse.cakephp.org/t/how-to-write-inner-join-in-cakephp-3-6-7/4668/2 "2018-08-06T08:04:16Z")
[Here it is](https://book.cakephp.org/3.0/en/orm/query-builder.html#using-innerjoinwith) 😉
---
### Author:  [@dash](https://discourse.cakephp.org/u/dash)
#### Post date: [August 6, 2018, 8:38am UTC](https://discourse.cakephp.org/t/how-to-write-inner-join-in-cakephp-3-6-7/4668/3 "2018-08-06T08:38:28Z")
anyone write for that above query…?
---
### Author:  [@Speudyland](https://discourse.cakephp.org/u/Speudyland)
#### Post date: [August 6, 2018, 8:49am UTC](https://discourse.cakephp.org/t/how-to-write-inner-join-in-cakephp-3-6-7/4668/4 "2018-08-06T08:49:30Z")
You should read the doc 🤓 you can also do it with the connection manager as well:
```
public function customQueryManager()
{
$c = ConnectionManager::get('default');
return $c
->query(
"SELECT * FROM users INNER JOIN registration ON users.id=registration.id WHERE users.id=7")
->fetchAll('assoc');
}
```
or by using join with the querybuilder 😉
---
### Author:  [@dash](https://discourse.cakephp.org/u/dash)
#### Post date: [August 6, 2018, 9:53am UTC](https://discourse.cakephp.org/t/how-to-write-inner-join-in-cakephp-3-6-7/4668/5 "2018-08-06T09:53:10Z")
i am using like this
$query1 = TableRegistry::get(‘users’)
-\>find()
-\>join(
[
‘table’ =\> ‘registration’,
‘type’ =\> ‘INNER’,
‘conditions’ =\> [
‘registration.id’ =\> ‘users.id’,
‘users.id’ =\> 1
]
]
);
**in that above query using in controller and how to call to design…?**
any suggestion…?
---
### Author:  [@dash](https://discourse.cakephp.org/u/dash)
#### Post date: [August 6, 2018, 11:20am UTC](https://discourse.cakephp.org/t/how-to-write-inner-join-in-cakephp-3-6-7/4668/6 "2018-08-06T11:20:06Z")
in that above code will written in controller right…?
---
### Author:  [@Speudyland](https://discourse.cakephp.org/u/Speudyland)
#### Post date: [August 6, 2018, 11:40am UTC](https://discourse.cakephp.org/t/how-to-write-inner-join-in-cakephp-3-6-7/4668/7 "2018-08-06T11:40:35Z")
No, you should add it in Model…
Probably you should do tutorial first or read [the ORM documentation](https://book.cakephp.org/3.0/en/orm.html) 😉
---
### Author:  [@dash](https://discourse.cakephp.org/u/dash)
#### Post date: [August 6, 2018, 12:07pm UTC](https://discourse.cakephp.org/t/how-to-write-inner-join-in-cakephp-3-6-7/4668/8 "2018-08-06T12:07:37Z")
i am not getting…