Question about Microsoft Computers & Internet
Suggest using Union Query. Thus, you can add more queries from many table and the output will be in one (1) query. Bear in mind that all fields must have same Field Name.
tblOne contains dtDate1 fieldname. Your query will select [tblOne].[dtDate1] As myDate.
tblTwo contains dtDate2 fieldname. Your query will have the following SQL:
Select [tblOne].[dtDate1] As myDate
UNION Select [tblTwo].[dtDate2] as myDate
Thus the output will result dates from tblOne and tblTwo in a column called myDate.
Posted on Feb 05, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
May 12, 2014 | Microsoft Database Software A5K-02817 SQL...
Sep 15, 2010 | Computers & Internet
Jun 16, 2009 | Microsoft Visual Basic Enterprise Edition...
Oct 19, 2008 | Microsoft MS SQL SERVER (810-01567-3-1)...
105 people viewed this question
Usually answered in minutes!