Many to One Merge

[robertrao]

Table1

Bee    MM

65       90

Table2

Bee    MM

42       90

81       90

60      90

When I merge table1 and Table2 bt MM I an not getting 65 under Bee Variable...Is it being overridden?????

Regards

[Astounding]

Yes.  What are you hoping to get?  There are at least four possible outcomes that I can imagine.