[release-18.0] fix: reference table join merge (#16488)

[release-18.0] fix: reference table join merge (#16488) #31536