"Column 'uid' in field list is ambiguous" error when joining user record to Webform view [#1447068]

When you create a view of Webform submissions and add a relationship to the User, it gives this error on the results list:
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'uid' in field list is ambiguous

Comments

Comment #1

quicksketch

he/him

CreditAttribution: quicksketch commented 25 February 2012 at 04:17

Status:

Active

» Postponed (maintainer needs more info)

I can't reproduce this problem in the 3.x dev version. Did you have to add any fields to the view? I added User: Name but it worked just fine. The resulting query:

SELECT webform_submissions.sid AS sid, users_webform_submissions.name AS users_webform_submissions_name, users_webform_submissions.uid AS users_webform_submissions_uid
FROM 
{webform_submissions} webform_submissions
LEFT JOIN {users} users_webform_submissions ON webform_submissions.uid = users_webform_submissions.uid
LIMIT 10 OFFSET 0