CREATE TABLE table_14312471_1 (away_team VARCHAR2, home_team VARCHAR2)

Who was the away team when Carlton was the home team?
SELECT away_team FROM table_14312471_1 WHERE home_team = "Carlton"
SELECT "away_team" FROM "table_14312471_1" WHERE "Carlton" = "home_team"