Subject Re: Merging 2 dbf From Randy Waldman <randwald@comcast.net> Date Fri, 06 Dec 2019 15:14:46 -0500 Newsgroups dbase.getting-started Akshat - your instructions are great.  I will try it. Akshat Kapoor Wrote: > On 06-12-2019 16:57, Randy Waldman wrote: > > 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? > > Using WHERE in union should work. Union just joins two sql statements > (Matching of fields is mandatory). Each of the sql statements can be > having conditions. > > But I have switched to MariaDB hence do not have any meaningful data in > dbf tables hence just performed a simple check. It worked. > > select company,directory from company2 where company = "XXXXXXXX" union > select company,directory from company > > I would recommend some checking before deploying. > (Company and company2 have different structures so I used the common > fields only) > > Prepare the two statements execute them and note down the number of rows > in each. > Then join them using union and then check the number of rows. > > > Please note : > The rowset so generated will be readonly. > > Regards > Akshat