<div>
THANKS! &nbsp;You save me some time... I searched for a similiar solution for hours... here's what worked... <br />
<br />
Select shipdate, date_in, orderno from orders where shipdate =&gt; bDate and shipdate =&lt; eDate UNION select shipdate, date_in, orderno from aorders where shipdate =&gt; bDate and shipdate =&lt; eDate
</div>


THANKS!  You save me some time... I searched for a similiar solution for hours... here's what worked...

Select shipdate, date_in, orderno from orders where shipdate => bDate and shipdate =< eDate UNION select shipdate, date_in, orderno from aorders where shipdate => bDate and shipdate =< eDate

<div>
<div class="content wysiwyg-content">
How do I combine two tables into one query? &nbsp;the tables are exact... so it's not a parent/child situation... the tables are current/archived data... when the user selects a date which falls into the archived data range... I would like to pull that data, in addition to any data n the current file which may also fall into the users selected date rage. &nbsp;I'm using a VFP-OLEDB connection in asp.net page... (vb)... <br />
<br />
I'm trying to populate a grid... then a crystal report... if the user desires to print.<br />
<br />
Something like select * from table1, table2 where dateshipped =&gt; etc...
</div>
</div>


How do I combine two tables into one query?  the tables are exact... so it's not a parent/child situation... the tables are current/archived data... when the user selects a date which falls into the archived data range... I would like to pull that data, in addition to any data n the current file which may also fall into the users selected date rage.  I'm using a VFP-OLEDB connection in asp.net page... (vb)... 

I'm trying to populate a grid... then a crystal report... if the user desires to print.

Something like select * from table1, table2 where dateshipped => etc...

Merge two tables in select query, vfp, oledb

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.