||Re: Merging 2 dbf
Randy Waldman <firstname.lastname@example.org>
||Fri, 06 Dec 2019 06:27:09 -0500
Akshat - so good to hear from you! Thanks for the reply. My further question: can I use WHERE clauses in my Union? Do you possibly have an example of such?
Akshat Kapoor Wrote:
> On 06-12-2019 01:34, Randy Waldman wrote:
> > dBase Plus19 User asking:
> > Is there a more efficient way to combine 2 databases with some of the fields the same:
> > My code:
> > SELECT * FROM tableA WHERE company = \'Discount Furniture'
> > Copy to MyMerge1
> > SELECT * FROM tableB WHERE company = \'Discount Furniture'
> > Copy to MyMerge2
> > USE MyMerge1
> > APPEND FROM myMerge2
> > If necessary to make a UNION or JOIN, I can select only the necessary matching fields.
> > Thanks, Randy
> Please go through the attached file. It is printout of local sql help.
> It will provide you with all necessay info.