Selecting From Dummy Tables

[dbagley]

Hey,

In Oracle, you can select literals from a table called 'DUAL'. Is there such a table in Access? I'm trying to just insert all literals into a table and need a dummy table name to select from.

Thanks,
Bagman

 

[rac2]

I doubt that Access has a DUAL table.

What about this?

INSERT decoder_ring (code, description)
VALUES ('y', 'Yes')

 

[dbagley]

Thanks rac2. I was trying to insert 3 rows with a union. Sort of like this:
INSERT decoder_ring (code, description)
select ('y', 'Yes')
union
select ('x','No')
union
select ('z','Yes');

This is when it complains about the missing table. In Oracle, I could just add 'From Dual' to each select stmt and it work ok. Maybe I'm just making this too complicated.

Thanks,
Bagman