The intellisense looks up the appropriate column.
However, when you select the column in the where clause intellisense adds another From clause after the where clause.
SELECT *
FROM [dbo].[Customer] AS c
WHERE c.[CardReference]
FROM [dbo].[Customer] AS c
I'm currently using MS SQL Server Management Studio.
However, when you select the column in the where clause intellisense adds another From clause after the where clause.
SELECT *
FROM [dbo].[Customer] AS c
WHERE c.[CardReference]
FROM [dbo].[Customer] AS c
I'm currently using MS SQL Server Management Studio.