Read this SQL tutorial ... to separate the table and column. If the column appears only in one of the referenced tables, you don’t need to include the fully qualified name, but it may be useful ...

This strategy helps you manage interrelated tables in your database. Click the Start button and launch the Microsoft SQL Server Management Studio. Click the Server Name menu and choose your server ...