Forum Discussion
Merge queries
One of the matching columns doesn't have any data i.e 'blank' . I removed that column from the table itself and then joined them . After that even though I am including that column I am still getting the desired output(no duplicate columns fromn the same table),surprising isn't it.
Tools works in weird way some time. Can't believe I spend so much time on this and still dont know the root cause even though I am getting desired results.
Hi Ankit041,
Glad to hear that you have got desired output. So, how did you resolve this problem?
Regards,
Yuliana Gu
One of the matching columns doesn't have any data i.e 'blank' . I removed that column from the table itself and then joined them . After that even though I am including that column I am still getting the desired output(no duplicate columns fromn the same table),surprising isn't it.
Tools works in weird way some time. Can't believe I spend so much time on this and still dont know the root cause even though I am getting desired results.
- Hi there I think it might be getting a better understanding of what the Merge is doing?
Once you have that understanding you can then use it so that it will work in the way that you understand, as well as know how to fully utilize it going forward.
What I would suggest is to Google Joins for Databases, which will explain the different joins and what they do.
