column reference is ambiguous

Two tables in the FROM list share that column name. Qualify it with the table name (after expanding short aliases, use the real table name).