# Difference between link and join

**URL:** https://discourse.cakephp.org/t/difference-between-link-and-join/4832
**Category:** Need Help
**Created:** [August 30, 2018, 5:41am UTC](https://discourse.cakephp.org/t/difference-between-link-and-join/4832 "2018-08-30T05:41:52Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![anujg1](https://avatars.discourse-cdn.com/v4/letter/a/35a633/32.png) [@anujg1](https://discourse.cakephp.org/u/anujg1)
#### Post date: [August 30, 2018, 5:41am UTC](https://discourse.cakephp.org/t/difference-between-link-and-join/4832/1 "2018-08-30T05:41:52Z")

</div>

Hi,  
In Cakephp 2.x, they are using link in queries.  
Example :

```
$branchesArray = $this->find('all', array(
        'conditions' => array('AND' => array(
                'FacilityGroupItems.facility_group_id' => $groupID,
            )
        ),
        'cacher' => true,
        'link' => array(
            'FacilityGroupItems' => array(
                'class' => 'FacilityGroupItems',
                'type' => 'inner',
                
                'conditions' => array('AND' => array(
                        "FacilityGroupItems.branch_id = Branches.id AND
        				FacilityGroupItems.facility_group_id = $groupID AND	        				
        				FacilityGroupItems.item_status_id != $soldStatusID AND
        				FacilityGroupItems.item_status_id != $inactiveStatusID AND
        				FacilityGroupItems.item_status_id != $workshopStatusID",
                        "NOT" => array(
                            "FacilityGroupItems.item_license_id" => null
                        )
                    )
                ),
                'fields' => array(
                    'FacilityGroupItems.branch_id', 'FacilityGroupItems.chassisno'
                )
            ),
       
        ),
        'fields' => array('Branches.id', 'Branches.name', 'Branches.code', 'Count(FacilityGroupItems.branch_id) as total_vehicles'),
        'group' => array('FacilityGroupItems.branch_id')
           
    )); 

```

How can I implement this in Cakephp 3.6?

Please suggest.

Regards  
Anuj

---

<div class="post-metadata">

### Author: ![mesiarm](https://avatars.discourse-cdn.com/v4/letter/m/4af34b/32.png) [@mesiarm](https://discourse.cakephp.org/u/mesiarm)
#### Post date: [August 31, 2018, 6:59pm UTC](https://discourse.cakephp.org/t/difference-between-link-and-join/4832/2 "2018-08-31T18:59:16Z")

</div>

Try to look at contain: [https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#eager-loading-associations-via-contain](https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#eager-loading-associations-via-contain)

---

<div class="post-metadata">

### Author: ![anujg1](https://avatars.discourse-cdn.com/v4/letter/a/35a633/32.png) [@anujg1](https://discourse.cakephp.org/u/anujg1)
#### Post date: [September 4, 2018, 3:51am UTC](https://discourse.cakephp.org/t/difference-between-link-and-join/4832/3 "2018-09-04T03:51:38Z")

</div>

thanks. Can we use Contain in place of Link in cakephp 3