You can use AS
for table aliasing on many SQL servers (at least MsSQL, MySQL, PostrgreSQL) but it’s always optional and on Oracle it’s illegal.
So remove the AS
:
SELECT G.Guest_ID, G.First_Name, G.Last_Name
FROM Guest G
You can use AS
for table aliasing on many SQL servers (at least MsSQL, MySQL, PostrgreSQL) but it’s always optional and on Oracle it’s illegal.
So remove the AS
:
SELECT G.Guest_ID, G.First_Name, G.Last_Name
FROM Guest G