I thnk I'm going to get crazy with a, for sure, easy question.
I have two queries I need to combine. We manage shops, sells and client surveys, but one of our shop uses a diferent survey system, so the data needs to be joined. We also use a global sale ID number for all the shops. The schema is quite this:
Sell ID // Shop // Channel // Survey response // Survey comments // and many other fields that are not in table 2.
In table 2 we have the same fields. Sell ID always matches with Table 1 (it's also registered there), Shop is always the city of the shop, it is common in Table 2, but in Table 1 we have another cities, Channel is if the sell was at the shop or online (that info is also in Table 1).
and many other fields, like prize, etc. In the table 2 we have a similar schema, but with less columns.
The thing is that Sell ID number can be in both tables (in fact, they are, all their sells are registered with that format). Information of both tables only changes in the survey fields, which is empty in the table 1. I need to choose the Sell ID, for example, and when it matches, pass the information of the Survey columns of the table 2 to the table 1. But only these 2 fields, keeping all the others like they are.
I tried to merge with all kind of combinations, and I could get the survey info in the merged query, but in exchange I lose all the other fields. of the table 1.
Did you try Merge queries feature? In the table 1, click Merge queries, then merge the table 2 to the table 1. You can select one or multiple columns as matching columns. This will not lose other fields of the table 1.
Best Regards, Community Support Team _ Jing If this post helps, please Accept it as Solution to help other members find it.