Unable to run query select r.dayno,r.monthname,r.year,trim(r.opponentb),r.fixture,r.score,r.result,s.league,r.dayname,r.uid,s.status,r.cupgame,r.cuptext from results r inner join season s on s.uid=r.sid where r.nextmatch=1