[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 899
  • Last Modified:

Merge two tables in select query, vfp, oledb

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...
0
zebasdad
Asked:
zebasdad
1 Solution
 
raterusCommented:
I'm not sure of your exact syntax, but it sounds as if a union operator is what you need to research.

Select *
from table1
where dateshipped = (...)
UNION
select *
from table2
where dateshipped = (...)
0
 
zebasdadAuthor Commented:
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
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now