Subject Re: Merging 2 dbf From Randy Waldman <randwald@comcast.net> Date Fri, 06 Dec 2019 06:27:09 -0500 Newsgroups dbase.getting-started 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. > > Regards > Akshat >