Ambiguous Column Reference Id

[zgunz42]

func (r *EmailMessageRepository) GetByID(ctx context.Context, id int) (*model.EmailMessage, error) {
	message := new(model.EmailMessage)
	err := r.db.NewSelect().Model(message).Where("id = ?", id).Relation("Events").Relation("Account").Scan(ctx)
	return message, err
}

Error Msg

pgdriver.Error {m: map[uint8]string [83: "ERROR", 86: "ERROR", 67: "42702", 77: "column reference "id" is ambiguous", 80: "619", 70: "parse_relation.c", 76: "831", 82: "scanRTEForColumn", ]}

[github-actions]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. If there is no update within the next 7 days, this issue will be closed.

[khanakia]

@zgunz42 how did you solve the issue ?

I could solve it using prefix the table name in where like this email_messages.id = 11