By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,962 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,962 IT Pros & Developers. It's quick & easy.

How to add my own rows to a query in MsAccess using Union,Dual Table

P: 16
How to add my own rows to a query in MsAccess ?

I would like to do something like this:
Select Name from Table 1 where age > 75
Union Select "Joe" from Dual;

Expected Result: If Joe is not found in Table 1 ,then it would be added to the result of the query.
How can I do it in MsAccess as it does not use " DUAL" table. Thanks for the help!
Dec 3 '11 #1
Share this Question
Share on Google+
1 Reply


100+
P: 1,059
Your question is really confusing.

If you write a statement like this:
Expand|Select|Wrap|Line Numbers
  1. SELECT 1;
  2.  
result would be 1

that is if you write something literal in select statement you will only get literal value. judge your question again and ask note below, then someone might be able to help you, but with this message nothing is clear
Dec 3 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.