[therealSqueeker]

I am trying to join 3 tables Med_Prof , Med_Prof_Facilities, and Med_Prof_Offices in SQL on Med_Prof_Record_No and keep getting Ambiguous column name erro . Any help would be great as I am not to good at this. Thanking you in advance

[Chicon]

Hi therealSqueeker,

You should either give alias names to your tables to differentiate the columns names or use the complete name of your columns.

Examples using tables tableA, tableB with common column name id:

SELECT * FROM tableA a
    INNER JOINT tableB b
        ON a.id = b.id

SELECT * FROM tableA
    INNER JOINT tableB
        ON tableA.id = tableB.id

[therealSqueeker]

Hi there!! Thank you so much...going to give it a try and let you know...tried something similar and it didn't work so keep your fingers crossed;-)

[therealSqueeker]

Ok....here's the latest error...

The number name 'MSO.dbo.Med_Prof.a' contains more than the maximum number of prefixes. The maximum is 3.

What the code looks like

FROM [MSO].[dbo].[Med_Prof] a
INNER JOIN [MSO].[dbo].[Med_Prof_Offices] b

ON [MSO].[dbo].[Med_Prof].a.[Med_Prof_Record_No]=[MSO].[dbo].[Med_Prof_Offices].b.[Med_Prof_Record_No]

[Chicon]

...
ON [MSO].[dbo].[Med_Prof].a.[Med_Prof_Record_No]=[MSO].[dbo].[Med_Prof_Offices].b.[Med_Prof_Record_No]

As a is an alias for [MSO].[dbo].[Med_Prof] and
b is an alias for [MSO].[dbo].[Med_Prof_Offices], the ON statement should be :
ON a.[Med_Prof_Record_No] = b.[Med_Prof_Record_No]

[therealSqueeker]

Thank you!