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:
Jan 19, 2016 | Microsoft SQL Server 2008 Enterprise Full...
on Sep 07, 2010 | Computers & Internet
Jul 04, 2014 | Microsoft SQL Server 2008 Enterprise Full...
Jun 16, 2009 | Microsoft Visual Basic Enterprise Edition...
Aug 30, 2007 | Microsoft SQL Server 2000 Standard Edition...
Aug 23, 2007 | Microsoft SQL Server Standard Edition for...
106 people viewed this question
Usually answered in minutes!