Jump to content

Every derived table must have its own alias


sseeley
 Share

Recommended Posts

Please can you help, I have a really easy query but cannot get past this error message.

 

 

SELECT cadetId, lastName, firstName FROM
(
SELECT tblcadets.pkCadetId AS cadetId, tblcadets.lastName AS lastName, tblcadets.firstName AS firstName
FROM tblcadets AS tblcadets
)

 

 

thanks for any help you can give me.

Link to comment
Share on other sites

As AyKay47 said, your query is doing the exact same as just a straight SELECT on that table.  However that said, to answer your question it is because you have a subquery so you need to alias that table in order for SQL to know what to refer to it as:

 

SELECT cadetId, lastName, firstName FROM
(
SELECT tblcadets.pkCadetId AS cadetId, tblcadets.lastName AS lastName, tblcadets.firstName AS firstName
FROM tblcadets AS tblcadets
)  AS a

Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.