I’m using a join in a query like the following:
// In CustomersTable. $this->find() ->select([/* what do I put here? */]) ->join([ 'Receipts' => [ 'table' => 'receipts', 'type' => 'INNER', 'conditions' => [ 'customers.id = receipts.customer_id' ] ] ]);
Note that this is a made-up example, but it illustrates my problem.
I can get all columns from
customers by leaving off the select query, or I can specify specific columns to include from both the
customers and the
receipts tables, but I need to get all columns from both tables. How can I do that?