I have a query with no alias AS
SELECT * FROM Students
LEFT OUTER JOIN Advisors
ON Students.[Advisor_ID] = Advisors.[Advisor_ID]
WHERE Advisors.[Advisor_ID] IS NULL ;
i want to replace table name Students by S and Advisors by A !
I try this with X or [X] but don't work ( SQL server syntax)
SELECT * FROM Students AS S
LEFT OUTER JOIN Advisors AS A
ON S.[Advisor_ID] = A.[Advisor_ID]
WHERE A.[Advisor_ID] IS NULL ;
any clue ?
All table has implicit row that contain null that appear if nothing match = is null !!!!