Is it BELONG_SF_ID replace provinces table province name
BELONG_SF_ID is province of table ID


Can I use Java turned out again in, don't know can direct SQL

CodePudding user response:

CodePudding user response:

If the province code table is belong_sf_dmb:
Select t. *, (the select wm_concat (s.b elong_sf_mc) from belong_sf_dmb s where instr (t.d elong_sf_id_, s.b elong_sf_id) & gt; 0) belong_sf_mc_
The from fxyd_zj_task t;

CodePudding user response:

The

reference 2 floor response:

if province code table is belong_sf_dmb:
Select t. *, (the select wm_concat (s.b elong_sf_mc) from belong_sf_dmb s where instr (t.d elong_sf_id_, s.b elong_sf_id) & gt; 0) belong_sf_mc_
The from fxyd_zj_task t;

666 bosses