php - 左连接的cakephp select语句

我有两个表是Servers和ApplicationsGroupsServers，其中server_id是Servers.id的外键。

我正在尝试编写查询以从服务器表中选择一个名为server_name的字段，并使左连接ApplicationsGroupsServers表中的所有数据。

$option = array(
    'join' => array(
            'table' => 'Servers',
            'alias' => 's',
            'type' => 'left',
            'conditions' => array( 's.id = ApplicationsGroupsServers.id' )
        )
);
$apps = $this->ApplicationsGroupsServers->find('all', array(
    "fields" => array('Servers.server_name'), ($option)
));
$this->set('applications', $apps);

但是，当我运行如下所示的查询时。我能够填充结果：

$apps = $this->ApplicationsGroupsServers->find('all', $option);

在后端运行的SQL查询：

SELECT ApplicationsGroupsServers.id AS `ApplicationsGroupsServers__id`,
    ApplicationsGroupsServers.application_id AS `ApplicationsGroupsServers__application_id`,
    ApplicationsGroupsServers.group_id AS `ApplicationsGroupsServers__group_id`,
    ApplicationsGroupsServers.server_id AS `ApplicationsGroupsServers__server_id`
FROM applications_groups_servers ApplicationsGroupsServers
     left JOIN Servers s ON s.id = ApplicationsGroupsServers.id

但是，我试图运行这样的事情：

SELECT server_name
  FROM applications_groups_servers
       LEFT JOIN servers
          ON servers.id = applications_groups_servers.server_id
       LEFT JOIN groups ON groups.id = applications_groups_servers.group_id

最佳答案

您应该尝试在模型之间创建关系，而不要使用join查询，但是如果您确实要使用join查询，请执行以下操作：

$options = array(
    'fields' => array(
        'Server.name' // Server not Servers
    ),
    'join' => array(
        array(
            'table' => 'servers',
            'alias' => 'Server',
            'type' => 'LEFT',
            'conditions' => array(
                'Server.id = ApplicationsGroupsServers.server_id',
            )
        ),
        array(
            'table' => 'groups',
            'alias' => 'Group',
            'type' => 'LEFT',
            'conditions' => array(
                'Group.id = ApplicationsGroupsServers.group_id',
            )
        )
    )
) ;

关于php - 左连接的cakephp select语句，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/32515108/