FOOTBALL : 1ère journée de ligue 1 le 8 août

SELECT cldom.nom hôte, clext.nom visiteur FROM champ_jour, champ_equipe as dom, champ_equipe as ext, champ_match, champ_club as cldom, champ_club as clext WHERE champ_jour.id_champ=261 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=1
1146: Table 'vienneanbois.champ_jour' doesn't exist

Error in table query 2
SELECT cldom.nom hôte, clext.nom visiteur FROM champ_jour, champ_equipe as dom, champ_equipe as ext, champ_match, champ_club as cldom, champ_club as clext WHERE champ_jour.id_champ=261 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=1
1146: Table 'vienneanbois.champ_jour' doesn't exist