sql语句关联关系的+号

看到了有个sql语句 居然后面带&＃43;号&＃xff0c;第一次看到就查了下

select

       t1.seq,

       t1.ID imid,

       t1.workdate,

       t1.plancode,

       t1.linestr,

       t1.workstastr,

       t1.WORKSTACODE,

       t1.workitem,

       t1.impact,

       t1.pgorgtype,

       s.orgnum,

       t2.PLAN_START_TIME AS PLANSTARTTIME,

       t3.id sdid,

       t3.SD_ML,

       t3.in_fhpersons SNPERSONID,

       t3.FLOW_STATE,

       t4.FLOW_STATE JXFLOW_STATE,

       p.pgorgid,

       t4.id jxsid

  from wxu_t_tc_import t1,

       wxu_t_tc_wc     t2,

       wxu_t_sdsq      t3,

       SYS_T_ORG       s,

       wxu_t_jxssq     t4,

       wxu_nn_t_pg     p

 where 1 &＃61; 1

   and t1.isdiscard &＃61; &＃39;0&＃39;

   and t1.id &＃61; t2.wxid(&＃43;)

   and t1.id &＃61; t3.TCID(&＃43;)

   and t1.id &＃61; t4.TCID(&＃43;)

   and (t1.zrgqid &＃61; s.id or (t1.zrgqid is null and t1.phzrgqid &＃61; s.id))

   and t1.id &＃61; p.tcid(&＃43;)

   and s.orgnum like &＃39;010202%&＃39;

   and t1.workdate >&＃61; &＃39;2016-11-18&＃39;

   and t1.workdate <&＃61; &＃39;2016-11-18&＃39;

   and (t1.plantype!&＃61;2 or t1.plantype is null)

 order by t1.seq, t1.workdate



&＃xff08;&＃43;&＃xff09;&＃xff1a;含义&＃xff1a;这个关联关系&＃xff0c;可有&＃xff0c;可无&＃xff1b;不影响主表数据的查询。