select * from (select * from Employees) as T1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I've used Sql Server a lot, and need to use MS Access for a small project.
I am trying to use a single SQL statement to do a sub-select, like:

select * from (select * from Employees) as T1

I cannot use a nested Sub-query because that requires me to physically alter
the database, and I don't have write access.

Does anyone know how to do this?

Thanks,
Tim
 
Jet gets a little "strange" with such setups, but this syntax should work:

SELECT T1.*
FROM
[SELECT * FROM Employees]. AS T1;
 
Your SQL String works fine in Access 2003.

In some earlier version, you may need to use square brackets like:

SELECT *
FROM
[SELECT * FROM Employees]. AS T1
 
Back
Top