The multi-part identifier "prod.product_id" could not be bound.

Sql Exception:

Msg 4104, Level 16, State 1, Line 266

The multi-part identifier "prod.product_id" could not be bound.

Fix:

Make sure the alias name "prod" exists in sql and correctly spelled.