J
jasontferrell
Is there a way in Access to create a query that contains the table
records within the query itself? I want to avoid creating a dummy
table and just use values within the query definition. I was thinking
about using syntax similar to the insert into statement I would use to
populate the dummy table, but I'm not sure if I have a syntax problem
or I'm trying to solve an impossible problem.
The query I'm thinking of might look something like this:
select *
from values("test");
-or-
select *
from (
("1/1/07","2/1/07","3/1/07","4/1/07","5/1/07","6/1/07")
);
records within the query itself? I want to avoid creating a dummy
table and just use values within the query definition. I was thinking
about using syntax similar to the insert into statement I would use to
populate the dummy table, but I'm not sure if I have a syntax problem
or I'm trying to solve an impossible problem.
The query I'm thinking of might look something like this:
select *
from values("test");
-or-
select *
from (
("1/1/07","2/1/07","3/1/07","4/1/07","5/1/07","6/1/07")
);