ERROR: Unknown column in WHERE clause

[Lester Cutchall]

Here is the trigger for the Song_Entry table after insert:

UPDATE Contest
SET Songs_Entered =
(Songs_Entered + 1)
WHERE Contest.Contest_id =
Song_Entry.Contest_id;

I keep getting the above error message that says Song_Entry.Contest_id is unknown.