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 Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only 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
Feb 08, 2015 | Microsoft SQL Server 2000 Standard Edition...
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...
109 people viewed this question
Usually answered in minutes!