Résultat Côtes d'Arey
SELECT cldom.nom hôte, CONCAT(buts_dom,' - ',buts_ext ) score,clext.nom visiteur
FROM usca_champ_jour AS champ_jour, usca_champ_equipe AS dom, usca_champ_equipe AS ext, usca_champ_match as champ_match, usca_champ_club AS cldom, usca_champ_club AS clext
WHERE champ_jour.id_champ =267
AND champ_match.id_equipe_dom = dom.id
AND champ_match.id_equipe_ext = ext.id
AND dom.id_club = cldom.id
AND ext.id_club = clext.id
AND champ_match.id_journee = champ_jour.id
AND cldom.nom != 'exempte'
AND clext.nom != 'exempte'
AND champ_jour.numero = (SELECT max(numero) FROM usca_champ_jour, usca_champ_match WHERE usca_champ_jour.id=usca_champ_match.id_journee and buts_dom is not NULL and usca_champ_jour.id_champ=267)
1146: Table 'vienneanbois.usca_champ_jour' doesn't exist
Erreur dans la requête de la table 27
SELECT cldom.nom hôte, CONCAT(buts_dom,' - ',buts_ext ) score,clext.nom visiteur
FROM usca_champ_jour AS champ_jour, usca_champ_equipe AS dom, usca_champ_equipe AS ext, usca_champ_match as champ_match, usca_champ_club AS cldom, usca_champ_club AS clext
WHERE champ_jour.id_champ =267
AND champ_match.id_equipe_dom = dom.id
AND champ_match.id_equipe_ext = ext.id
AND dom.id_club = cldom.id
AND ext.id_club = clext.id
AND champ_match.id_journee = champ_jour.id
AND cldom.nom != 'exempte'
AND clext.nom != 'exempte'
AND champ_jour.numero = (SELECT max(numero) FROM usca_champ_jour, usca_champ_match WHERE usca_champ_jour.id=usca_champ_match.id_journee and buts_dom is not NULL and usca_champ_jour.id_champ=267)
1146: Table 'vienneanbois.usca_champ_jour' doesn't exist