HI I have a query with no alias AS SQL9 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) SQL9 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 !!!! Attachments: loop9_v3.png loop_v9.mxb
Book about Science , cosmological model , Interstellar travels Boyle surface fr ,en |