CREATE TABLE table_1013129_8 (nhl_team VARCHAR2, player VARCHAR2)

Which NHL team has player Mike Loach?
SELECT nhl_team FROM table_1013129_8 WHERE player = "Mike Loach"
SELECT "nhl_team" FROM "table_1013129_8" WHERE "Mike Loach" = "player"