To replicate this one follow the following steps: -
1.) Open Northwind database in Query Analyzer.
2.) Write the following query.
SELECT FROM [Region]
3.) Now try to add the columns RegionID and RegionDescription using "Columns from all tables" list between SELECT and FROM as in the following query
SELECT [Region].[RegionID], [Region].[RegionDescription] FROM [Region]
The fields [Region].[RegionID] and [Region].[RegionDescription] are included in the "All common objects" list but not included in the "Columns from all tables" list.
None of the fields for table Region are included in "Columns from all tables" list.
1.) Open Northwind database in Query Analyzer.
2.) Write the following query. 3.) Now try to add the columns RegionID and RegionDescription using "Columns from all tables" list between SELECT and FROM as in the following query The fields [Region].[RegionID] and [Region].[RegionDescription] are included in the "All common objects" list but not included in the "Columns from all tables" list.
None of the fields for table Region are included in "Columns from all tables" list.