Skip to content
Advertisement

Ambiguous Source ID

I’m not sure what I’m doing wrong here. I tried to make an alias because it exits as an item in both tables I’m trying to join, but I keep getting an ambiguous error for sourceId.

Advertisement

Answer

try this

change the alias for select depending on which table it is in

Also are you purposely joining on columns from the same table? Or should one of those identifiers be ‘cm’

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement