sql - Table not found in subquery using Microsoft Access 2010 -

-

I am trying to use subqueries in Microsoft Access 2010. Here is the table "Table1": 

  ID data -------- 1 ABC2DF

There are two possible uses of the subkey: < / P> 

  Select ID (selection ID from Table 1) AS TMP WHERE tmp.ID & gt; 1

This works, and returns the correct result ID = 2. However, as a select ID (selection ID from Table 1) from 

 , TMP where EXIST (

returns the following error:

< Blockquote>

Microsoft Access Database Engine input table or query 'TMP can not be found', make sure it exists and its name is spelled correctly.

Is not a good example, but give me another subquery reference in more complex cases SAPT for SRTing by SELECT Temp.Rating (Select, AVG as SAG) SAP Temporary Time Temporary Time (SELECT MIN (Temp) .avgage)

What is the reason for such errors and how to solve it?

There are a lot easier ways for you to suggest.

For example, your second query may be re-applied in such a way:

< Pre> Select Top 1 SRT, as Aviga from sailors s group by average (sag) s.

This gives you the lowest average age of sailors grouped by their rating.

If you have to use the sub-group then try: 

  Selection Rating, from the lowest (avg) (Selection SRT, AVG (SAG) Average, by the Assessors S Group SRTing) ASTP

In the first section of your reply, you give this query: 

 From  to selection ID (Selection ID from Table 1) TMP where current (TMP WHERE ID & gt; 1) by selection IDs

This throws a syntax error because tmp Gunnja WORD is present.

I think that means you do something like that, though I'm not sure that it makes sense: