Navn på tabel

Your tables which you want to JOIN must exist already.

Make sure´you have TWO tables before trying to make a query.
BOTH tables should have a primary key (unique index) and one of them should have a field which references the primary key in the OTHER table. This is called a foreign key.
The easiest way to do this is add a new field to your table and select LOOK UP WIZARD from the data types. Then you will be asked to select the table you want to use.
Now when you make the query add BOTH fields and there should appear a thin line between the two tables. This is your JOIN!

Er det ikke muligt at gøre det på den måde som jeg beskriver i spørgsmålet?

Det skal lige nævnes at jeg foretager opkaldet i ASP

HOW can you join to a table which doesnt exist?

Is this what you mean?
SELECT *
FROM tblTestDelete AS tbl1 INNER JOIN newtable AS tbl2 ON tbl1.ID =tbl2.nummer;

Jep. Det er det jeg mener. Desværre får jeg en fejl når jeg forsøger at køre det:
Microsoft JET Database Engine error '80040e10'
Der er ikke angivet nogen værdi for en eller flere krævede parametre.

Jeg har newtable som en sub-query (Select ...) mens tblTestDelete er en almindelig tabel.

Ups, min fejl. Det virker. Tak.