Table Aliases
have this query for ServiceDesk Plus 9.4 and mssql 2014 having trouble finding the table aliases: can someone please help
ELECT
[CI].[CINAME],
[ChangeDetails].[CHANGEID],
[ChangeDetails].[TITLE],
[ChangeDetails].[DESCRIPTION],
[ChangeDetails].[COMPLETEDTIME]
FROM [ChangeDetails]
LEFT JOIN ChangeToCI on ChangeDetails.ChangeID = ChangeToCI.ChangeID
LEFT JOIN CI on ChangeToCI.CIID = CI.CIID
order by [ChangeToCI].[CIID]
Thank yoiu
Rich Gruenfelder