Ambiguous column name

[theknight]

SQL error

Ambiguous column name 'StaffMember_Id'.

SELECT KeyworkerAssignments.Id, EffectiveFrom, EffectiveFrom, Child_Id, StaffMember_Id FROM Contacts JOIN KeyWorkerAssignments ON KeyworkerAssignments.StaffMember_Id=Contacts.StaffMember_Id WHERE Child_Id=4

I'm joining 2 tables but it seems to be throwing this error, why?

[bradgrafelman]

It's throwing that error because 'StaffMember_Id' is an ambiguous column name. 🙂

Which table is that column defined in; pick ONE of KeyworkerAssignments or Contacts. Confused? So is MySQL; name one of the tables explicitly in the SELECT list rather than just the ambiguous 'StaffMember_Id' (which matches the name of a column appearing in more than one table).

[theknight]

bradgrafelman;10985797 wrote:

It's throwing that error because 'StaffMember_Id' is an ambiguous column name. 🙂

Which table is that column defined in; pick ONE of KeyworkerAssignments or Contacts. Confused? So is MySQL; name one of the tables explicitly in the SELECT list rather than just the ambiguous 'StaffMember_Id' (which matches the name of a column appearing in more than one table).

Thanks
I chose Keyworkerassignments, seemed to have worked.

$this->db->select("KeyworkerAssignments.Id, EffectiveFrom, EffectiveFrom, Child_Id, KeyworkerAssignments.StaffMember_Id");