Hi, there!
I want to append TABLE1 in current DB1 to TABLE ALL in DB2. TABLE1 contains only one month of data. TABLE ALL contains year-to-date data. In this case, do I have to use append query to create a year-to-date table in DB1 first, then export it to DB2? Or there is some other way?
Many many thanks in advance
I want to append TABLE1 in current DB1 to TABLE ALL in DB2. TABLE1 contains only one month of data. TABLE ALL contains year-to-date data. In this case, do I have to use append query to create a year-to-date table in DB1 first, then export it to DB2? Or there is some other way?
Many many thanks in advance