select j.u ser_id, s.u sername from AR_JPUSH_USER j join sysuser s on s.u serid=j.u ser_id 

Dared ask your bosses, when s.u serid condition is cuilichen, lichen, how can and j.u ser_id corresponding, figure 1 is how to get the red box?

CodePudding user response:

Use listagg stitching, but you have to give a unified the unique value of the two