There is a request

SELECT `id`, `group_id`, `option_id`, `media_id` FROM `s_articles` AS `articles` INNER JOIN `s_article_configurator_set_group_relations` `set_groups` ON `articles`.`configurator_set_id` = `set_groups`.`set_id` INNER JOIN `s_article_configurator_set_option_relations` `set_options` ON `articles`.`configurator_set_id` = `set_options`.`set_id` RIGHT JOIN `s_articles_img` ON `articles`.`id` = (SELECT `articleID` FROM `s_articles_img` WHERE `articleID` IS NOT NULL);

An error is displayed during execution.

Столбец 'id' в field list задан неоднозначно

    2 answers 2

    Replace

     SELECT `id`, `group_id`, `option_id`, `media_id`

    on

     SELECT `table_name.id`, `group_id`, `option_id`, `media_id`

    Better yet, with INNER JOIN, always write like this:

     SELECT `table_name.id`, `table_name.group_id`, `table_name.option_id` ...

      Presumably, the id column is in several tables and, accordingly, it is unclear which query to take with this query. Therefore, it should be indicated explicitly, as well as other fields too.

       SELECT NEEDED_TABLE_NAME.`id`, NEEDED_TABLE_NAME.`group_id`, NEEDED_TABLE_NAME.`option_id`, NEEDED_TABLE_NAME.`media_id`
      • Sorry but articles.id is written - Samvel
      • one
        SELECT `id`, `group_id`, `option_id`, `media_id` - where? - Alexey Shimansky
      • but I see, thanks) - Samvel