# Selected Column

**URL:** <https://discourse.cakephp.org/t/selected-column/1438>\
**Category:** Uncategorized\
**Created:** [November 3, 2016, 11:18am UTC](https://discourse.cakephp.org/t/selected-column/1438 "2016-11-03T11:18:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nagendra1020](https://avatars.discourse-cdn.com/v4/letter/n/82dd89/32.png) [@nagendra1020](https://discourse.cakephp.org/u/nagendra1020)\
**Post date:** [November 3, 2016, 11:18am UTC](https://discourse.cakephp.org/t/selected-column/1438/1 "2016-11-03T11:18:18Z")

</div>

Hi,  
ModelA  
FILED 1  
FILED 2  
FILED 3  
FILED 3  
ModelB  
FILED X  
FILED Y  
FILED X  
ModelC  
FILED A  
FILED B  
FILED C

ModelA #hasMany array(ModelB, ModelC)

I want few filed from ModelB and ModelC  
i want FILED X and FILED Y from ModelB and FILED A and FILED B from ModelC Using Pagination how can i get?

---

<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:** [November 4, 2016, 1:48pm UTC](https://discourse.cakephp.org/t/selected-column/1438/2 "2016-11-04T13:48:21Z")

</div>

Something like this should do what you want.

`$this->find()->select(['ModelB.fieldX', 'ModelC.fieldA])->contain(['ModelB', ModelC])`