We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.
  1. Home
  2. General

Issue with multiple join

return $this->modelsManager->createBuilder() ->columns('Channels.apiKey') ->from('Channels') ->innerJoin('SspChannelAd', 'Channels.ssp_channel_ad_id = SspChannelAd.id ') ->innerJoin('SspChannel', 'SspChannelAd.channel_id = SspChannel.id') ->where('SspChannel.publisher_id=1') ->getQuery() ->execute() ->toArray();



77.7k
return $this->modelsManager->createBuilder() 
    ->columns('Channels.apiKey')
    ->from('Channels')
    ->innerJoin('SspChannelAd', 'Channels.sspchannelad_id = SspChannelAd.id ')
    ->innerJoin('SspChannel', 'SspChannelAd.channel_id = SspChannel.id')
    ->where('SspChannel.publisher_id=1')
    ->getQuery() ->execute() ->toArray();

But what is the error? Does it stop with an exception, do you get bad results?



427

Yes It's stop with an exception.



77.7k

And what does the exception say? If you want some help, you'd better provide all the info that's necessary :]