Multi-Part Identifier - Namespace Issue I believe <pre><code>USE VISION_DB SELECT tpi.ProfileName, tic.ChannelName FROM T_PROFILE_INFO tpi, T_INPUT_CHANNEL_INFO tic, T_PROFILE_CHANNELS INNER JOIN T_PROFILE_CHANNELS tpc ON tpc.ProfileID = ***T_PROFILE_INFO.ProfileID*** AND tpc.ChannelID = ***T_INPUT_CHANNEL_INFO.ChannelID*** </code></pre> <p>I am able to return the multi-part identifier alert for each of the two entries highlighted.</p> <p>The alias <code>tpc</code> is referenced correctly, but the right side of each expression will not. I have substituted the alias' from the <code>FROM</code> clause, but they are out of scope here.</p> <p>I have been trying to sort this for some time. I believe there is a namespace issue, but do not know how to reference the changes required.</p> <p>I run across this issue regularly, but have always been able to resolve it with a search. I can find nothing that appears to clear this up.</p>