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 ...