Ambiguous column reference when joining

Question

Structs

type Client struct {
   Id int64
   Name string
}

type Trade struct {
   Id int64
   ClientId int64
   Client *Client
}

Query db.Model(&Trade).Where("id = ", tradeId).Relation("Client").Select()

Error encountered: Column Id ambiguous. Not sure what's the proper way to work around this Would be great if someone can help

Answer 1

You may try qualifying the Id column with either an alias or the full table name, e.g.

db.Model(&Trade).Where(`"Trade".id = ?`, tradeId).Relation("Client").Select()