Champ id ambigue [Résolu]

[apt]

Salut à tous,

En essayant de faire une requête SQL, je reçois cette erreur :

requête SQL: Documentation

SELECT id, title, uploadfile, catmig, cat_id, rafia_cat.id, rafia_cat.title
FROM rafia_articles a, rafia_cat c
INNER JOIN rafia_cat ON a.cat_id = c.id
WHERE allow = 'yes'
ORDER BY rafia_articles.id DESC
LIMIT 0 , 3

MySQL a réponduocumentation
#1052 - Column 'id' in field list is ambiguous

Structure de la table :

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
`rafia_articles` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `cat_id` int(255) NOT NULL DEFAULT '0',
  `title` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
  `date_time` int(11) NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `userid` int(11) NOT NULL DEFAULT '0',
  `name` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
  `articles_head` text collate latin1_general_ci NOT NULL,
  `post` longtext collate latin1_general_ci,
  `allow` char(3) collate latin1_general_ci NOT NULL DEFAULT '',
  `inindex` int(1) NOT NULL DEFAULT '1',
  `inmenu` int(1) NOT NULL DEFAULT '1',
  `main` tinyint(1) NOT NULL DEFAULT '0',
  `catmig` int(1) NOT NULL DEFAULT '0',
  `reader` int(10) DEFAULT '0',
  `c_comment` int(10) DEFAULT '0',
  `sticky` tinyint(2) NOT NULL DEFAULT '0',
  `close` int(1) NOT NULL DEFAULT '0',
  `rating_total` int(10) NOT NULL DEFAULT '0',
  `ratings` int(10) NOT NULL DEFAULT '0',
  `datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lastuserid` int(11) NOT NULL DEFAULT '0',
  `timestamp` int(11) NOT NULL DEFAULT '0',
  `uploadfile` int(10) NOT NULL DEFAULT '0',
  `ues_editor` int(1) NOT NULL DEFAULT '0',
  `edit_by` varchar(255) collate latin1_general_ci NOT NULL DEFAULT '0',
  PRIMARY KEY  (`id`),
  KEY `timestamp` (`timestamp`),
  KEY `cat_id` (`cat_id`),
  KEY `userid` (`userid`),
  FULLTEXT KEY `post` (`post`),
  FULLTEXT KEY `articles_head` (`articles_head`),
  FULLTEXT KEY `title` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6 ;

Structure de la table :

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
`rafia_cat` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ordercat` int(10) NOT NULL DEFAULT '0',
  `catType` int(3) NOT NULL DEFAULT '0',
  `subcat` int(10) NOT NULL DEFAULT '0',
  `title` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
  `dsc` text collate latin1_general_ci NOT NULL,
  `dscin` text collate latin1_general_ci NOT NULL,
  `countopic` int(10) NOT NULL DEFAULT '0',
  `countcomm` int(10) NOT NULL DEFAULT '0',
  `lastpostid` int(11) NOT NULL DEFAULT '0',
  `moderateid` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '0',
  `ismine` tinyint(2) NOT NULL DEFAULT '0',
  `groupost` varchar(200) collate latin1_general_ci NOT NULL DEFAULT '0',
  `groupview` varchar(200) collate latin1_general_ci NOT NULL DEFAULT '0',
  `cat_email` varchar(255) collate latin1_general_ci DEFAULT NULL,
  `catClose` char(1) collate latin1_general_ci NOT NULL DEFAULT '0',
  `homeshow` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=397 ;

Merci.

[Madfrix]

Bonsoir,

c'est relativement parlant comme erreur non...?

Met un alias ici :

Code sql :

1
2
 
SELECT id...

[ninikkhuet]

Bonjour,

attention à bien mettre les alias, et ce n'est pas la peine de mettre la table rafia_cat dans le FROM si tu l'as déjà dans le inner join.

Code :

1
2
3
4
5
6
7
8
9
10
11
SELECT a.id,
       a.title,
       a.uploadfile,
       a.catmig,
       a.cat_id,
       c.id,
       c.title
  FROM rafia_articles AS a INNER JOIN rafia_cat AS c ON a.cat_id = c.id
 WHERE a.allow = 'yes'
ORDER BY a.id DESC
 LIMIT 0, 3

[apt]

Merci ninikkhuet et Madfrix