CONVERT ORACLE SQL TO EQUIVALENT ACCESS SQL ( using Oracle "dual" table )
Posted on 2004-09-09
Hi All - wonder if anyone can help me with this ?
I am trying to convert an Oracle query in to an Access 2000 query.
I'm struggling with the following.
Within the FROM statement (of the oracle query) there is a subquery which looks like this ;
(select table1.field1, table1.field2 from table1_long_name table1, table2_long_name table2
where table1.cor_id = table2.id and table2.reference in ('name1','name2','name3','name4')
union select 'MISSING NUMBER', 'MISSING NUMBER' from dual)
what would the equivalent Acess SQL be ?
Don't really understand this whole 'dual' caper at all ?