Every derived table must have its own alias

[sseeley]

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.

[AyKay47]

this query makes no sense..

 

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

[awjudd]

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

[sseeley]

Thats great, thanks