SQL semantics

[Kalin]

Does anybody know is the following is possible in Access ??
If so what is the correct syntax ??

SELECT column FROM (SELECT column FROM table) AS alias;

 

[lameid]

No. But you can create a query with an SQL statement and base another query off of that. It's like querying a view in SQL server.

 

[tlbroadbent]

Actually, you can use syntax similar to that which you describe - at least in Access 2000. I'll check Access 97 when I get to work.

I just created this query and ran it in Access 2000.

SELECT a.Dept
FROM [SELECT *
FROM Depts]. AS a;

I typed the query in with () and Access chenged them to [] and added the period. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.