ode1
> AND t.teamCode <> g.teamCode2
> AND g.gameTurn = r.code;
>
> ...and even the table "Turn" may not be necessary, depending
> on the values
> in your tables and what you want to do with it.
>
>
> - Original Message -
> From: "Lefebvre, Cedr
I have a problem adapting a multiple select to MySQL.
Can someone help me ?
Here is my request (Oracle format)
SELECT Tactic.teamCode FROM Tactic WHERE
Tactic.teamCode NOT IN (SELECT Game.teamCode1 FROM Game, Turn WHERE
Game.gameTurn = Turn.code)
AND Tactic.teamCode NOT IN (SELECT Game.teamCode2
