Tough crowd in here...  

I was thinking.  Could I have trouble accessing the 'offline' alias outside the brackets?  How about this?

SET nc_materials_id = (SELECT offline.nc_materials_id

                               FROM dev.test_ed.dbo.nc_incident_materials AS offline...

Ok.  I have been working on this.  First, I do want to learn but I need to speed this along which is why I am posting here.  I am not...

Thank you.  I can pull the data from each DB individually but my join is failing.  Here is the basic select to see the data. 

can you help me with...