Table schema:
CREATE TABLE table_1473672_2 (nhl_team VARCHAR, player VARCHAR)

Question: What nhl team does stan weir play for?
SQL: SELECT nhl_team FROM table_1473672_2 WHERE player = "Stan Weir"