CREATE TABLE table_29090919_1 (away_team VARCHAR, home_team VARCHAR)

Which team was the away team when home team was essendon?
SELECT away_team FROM table_29090919_1 WHERE home_team = "Essendon"
SELECT "away_team" FROM "table_29090919_1" WHERE "Essendon" = "home_team"