[FIXED] how to select all records from one table and some from another table in cakephp 3.6

Issue

SELECT myTable.*, otherTable.foo, otherTable.bar...

how can we write above query in cakephp ? I tried this but didn't work.

$data = $this->Articles->find()->select(['Articles.*','Categories.name'])->innerJoineWith('Categories');

It giving me error near SELECT Fees.* ASFees__*.

So instead of that, I have to write all columns of the Article Table.

$data = $this->Articles->find()->select(['Articles.id','Articles.name','Articles.title','Articles.description','Categories.name'])->innerJoineWith('Categories');

is there any solution in cakephp? please tell me. Thank You.

Solution

$data = $this->Articles->find()
        ->select($this->Articles)
        ->select(['Categories.name'])
        ->innerJoineWith('Categories');

Answered By - 26vivek