Bonjour,
j'ai beau chercher, je ne comprends pas pourquoi SELECT s.name FROM `statustype` s INNER JOIN `tickets` t ON t.Statustype=s.id where (t.id="INC000006733169") ne donne aucun résultat alors que SELECT p.name FROM `prioritytype` p INNER JOIN `tickets` t ON t.Prioritytype=p.id where (t.id="INC000006733169") en donne un.
statustype :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15 DROP TABLE IF EXISTS `statustype`; CREATE TABLE IF NOT EXISTS `statustype` ( `id` smallint(3) NOT NULL AUTO_INCREMENT, `name` varchar(13) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; DROP TABLE IF EXISTS `statustype`; CREATE TABLE IF NOT EXISTS `statustype` ( `id` smallint(3) NOT NULL AUTO_INCREMENT, `name` varchar(13) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
proritytype :
Code sql : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8 DROP TABLE IF EXISTS `prioritytype`; CREATE TABLE IF NOT EXISTS `prioritytype` ( `id` smallint(2) NOT NULL AUTO_INCREMENT, `name` varchar(6) COLLATE latin1_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
tickets :
Code sql : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22 DROP TABLE IF EXISTS `tickets`; CREATE TABLE IF NOT EXISTS `tickets` ( `id` varchar(18) COLLATE utf8_bin NOT NULL, `Product_Name` varchar(25) COLLATE utf8_bin DEFAULT NULL, `Assigned_Group` varchar(30) COLLATE utf8_bin DEFAULT NULL, `Submitted_Date` datetime NOT NULL, `Last_Resolved_Date` datetime NOT NULL, `Summary` varchar(200) COLLATE utf8_bin NOT NULL, `Prioritytype` smallint(2) NOT NULL, `Statustype` smallint(3) NOT NULL, `Area` varchar(10) COLLATE utf8_bin DEFAULT NULL, `Country` varchar(10) COLLATE utf8_bin DEFAULT NULL, `Submitter_SESA` int(6) NOT NULL, `Customer_SESA` int(6) NOT NULL, `Organization` varchar(30) COLLATE utf8_bin DEFAULT NULL, `Incident_Type` varchar(20) COLLATE utf8_bin DEFAULT NULL, `Reported_Source` varchar(20) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`id`), KEY `Prioritytype` (`Prioritytype`), KEY `Statustype` (`Statustype`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Partager