sql - How do I view records from a table in a different schema?

Question

Besides using linked server, how do I view records from a table in a different schema?

so if I have table in [eg].[info] and another table in [ie].[info], how do I join them together? That is one schema is [eg] and the other is schema [ie].

Answer 1

You need to alias the tables with AS (which you should always do anyway):

FROM eg.info AS info1
JOIN ie.info AS info2