Problem with simple Join table about gorm HOT 2 CLOSED

Hi @duskhacker

Thank you for your report.

I have fixed the SQL logging issue, please update gorm and retry.

For the simple join issue, I have checked in my local, here is the sql results:

the column name are id address id user_id email_id, gorm will assign the last id (the third column) as the email's id, but actually it is user_email's id. so it caused this error.

In order to fix it, you should use select to avoid ambiguous column name like this:

Db.Table("emails, user_emails").Select("emails.id, emails.address").Where("user_emails.user_id = ? and emails.id = user_emails.email_id", user.Id).Find(&foundEmails)

Let me think if there is a better solution to fix the confusion. Thank you

from gorm.

Hi,

Thanks for the quick response.

I can confirm the SQL logging issue is fixed.

Although the workaround you mention requires duplicating field information in the query, it does work, so it's an acceptable workaround for now.

Thank you!

from gorm.