SELECT j.Nom,j.Prenom FROM alignement a,joueurs j Where NoDG = 2 and a.DefButeur = j.NoJoueur and a.Mois = 7Pulock Ryan ------------------------- Butcher Will Gustafsson Erik Hicketts Joe Manson Josh McDonagh Ryan Morrissey Josh Pesce Brett Pulock Ryan Slavin Jaccob

SELECT j.Nom,j.Prenom FROM alignement a,joueurs j Where NoDG = 2 and a.DefPasseur = j.NoJoueur and a.Mois = 7Gustafsson Erik ------------------------- Butcher Will Gustafsson Erik Hicketts Joe Manson Josh McDonagh Ryan Morrissey Josh Pesce Brett Pulock Ryan Slavin Jaccob

SELECT j.Nom,j.Prenom FROM alignement a,joueurs j Where NoDG = 2 and a.DefPlusMoins1 = j.NoJoueur and a.Mois = 7Morrissey Josh ------------------------- Butcher Will Gustafsson Erik Hicketts Joe Manson Josh McDonagh Ryan Morrissey Josh Pesce Brett Pulock Ryan Slavin Jaccob

SELECT j.Nom,j.Prenom FROM alignement a,joueurs j Where NoDG = 2 and a.DefPlusMoins2 = j.NoJoueur and a.Mois = 7Slavin Jaccob ------------------------- Butcher Will Gustafsson Erik Hicketts Joe Manson Josh McDonagh Ryan Morrissey Josh Pesce Brett Pulock Ryan Slavin Jaccob

SELECT j.Nom,j.Prenom FROM alignement a,joueurs j Where NoDG = 2 and a.DefGoon = j.NoJoueur and a.Mois = 7Manson Josh ------------------------- Butcher Will Gustafsson Erik Hicketts Joe Manson Josh McDonagh Ryan Morrissey Josh Pesce Brett Pulock Ryan Slavin Jaccob

SELECT j.Nom,j.Prenom FROM alignement a,joueurs j Where NoDG = 2 and a.Def6e = j.NoJoueur and a.Mois = 7McDonagh Ryan ------------------------- Butcher Will Gustafsson Erik Hicketts Joe Manson Josh McDonagh Ryan Morrissey Josh Pesce Brett Pulock Ryan Slavin Jaccob

SELECT j.Nom,j.Prenom FROM alignement a,joueurs j Where NoDG = 2 and a.AttAG1e = j.NoJoueur and a.Mois = 7Mantha Anthony ------------------------- Beauvillier Anthony Dvorak Christian Fiala Kevin Johnsson Andreas Kerfoot Alexander Mantha Anthony Marchand Brad Vrana Jakub

SELECT j.Nom,j.Prenom FROM alignement a,joueurs j Where NoDG = 2 and a.AttC1e = j.NoJoueur and a.Mois = 7Zibanejad Mika ------------------------- Beauvillier Anthony Dvorak Christian Eichel Jack Hughes Jack Kerfoot Alexander Point Brayden Zibanejad Mika

SELECT j.Nom,j.Prenom FROM alignement a,joueurs j Where NoDG = 2 and a.AttAD1e = j.NoJoueur and a.Mois = 7Svechnikov Andrei ------------------------- Beauvillier Anthony Brown Connor Fiala Kevin Mantha Anthony Pastrnak David Point Brayden Svechnikov Andrei Vrana Jakub