-
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND Jogo.CodJogo IN (SELECT CodJogo FROM JogoAudio)
' at line 13
SQL: SELECT Jogo.CodJogo, e1.Descricao as e1Descricao, e2.Descricao as e2Descricao, ValorPrimarioMandante, ValorPrimarioVisitante, DATE(Jogo.DataHora) as Data, TIME(Jogo.DataHora) as Hora FROM Jogo INNER JOIN Equipe e1 ON e1.CodEquipe = Jogo.CodMandante INNER JOIN Equipe e2 ON e2.CodEquipe = Jogo.CodVisitante WHERE Jogo.CodEdicao = AND Jogo.CodJogo IN (SELECT CodJogo FROM JogoAudio) ORDER BY Jogo.DataHora DESC
SQL: SELECT Jogo.CodJogo, e1.Descricao as e1Descricao, e2.Descricao as e2Descricao, ValorPrimarioMandante, ValorPrimarioVisitante, DATE(Jogo.DataHora) as Data, TIME(Jogo.DataHora) as Hora FROM Jogo INNER JOIN Equipe e1 ON e1.CodEquipe = Jogo.CodMandante INNER JOIN Equipe e2 ON e2.CodEquipe = Jogo.CodVisitante WHERE Jogo.CodEdicao = AND Jogo.CodJogo IN (SELECT CodJogo FROM JogoAudio) ORDER BY Jogo.DataHora DESC