select
TB_ITEM_DEPLOY.F_ITEM_CODE AS F_ITEM_CODE,
TB_ITEM_DEPLOY.F_MEDIA_CODE1 AS F_MEDIA_CODE1,
TB_ITEM_DEPLOY.F_ITEM_NAME AS F_ITEM_NAME,
TB_ITEM_DEPLOY.F_AUTO_ID AS F_AUTO_ID,
TB_ITEM_DEPLOY.F_ORDER AS F_ORDER,TB_ITEM_INFO.F_POINT_CODE AS F_POINT_CODE,
TB_ITEM_INFO.F_CODE1 AS F_CODE1,
TB_ITEM_INFO.F_CODE2 AS F_CODE2,
TB_ITEM_INFO.F_DEPT_CODE AS F_DEPT_CODE,
TB_ITEM_INFO.F_POSITION AS F_POSITION,
TB_ITEM_INFO.F_FLAG AS F_FLAG FROM
TB_ITEM_DEPLOY LEFT OUTER JOIN TB_ITEM_INFO ON
(TB_ITEM_DEPLOY.F_ITEM_CODE = TB_ITEM_INFO.F_ITEM_CODE) and (TB_ITEM_INFO.F_POINT_CODE = '444444') WHERE
(TB_ITEM_DEPLOY.F_MEDIA_CODE1 = '11')---------------------------------------------其中“TB_ITEM_DEPLOY”和“TB_ITEM_DEPLOY”为左外连接查询的两个表的表名。最关键有疑问的地方是:这条SQL语句中,ON条件后面除了通常建立连接查询所需的两表对应字段的条件外,还有一个:“(TB_ITEM_INFO.F_POINT_CODE = '444444')”这样的条件,而且这个条件会对查询结果有很大的影响,请问这个ON后面的条件是什么意思?并且这条SQL语句如何改为Nhibernate使用的SQL语句?
TB_ITEM_DEPLOY.F_ITEM_CODE AS F_ITEM_CODE,
TB_ITEM_DEPLOY.F_MEDIA_CODE1 AS F_MEDIA_CODE1,
TB_ITEM_DEPLOY.F_ITEM_NAME AS F_ITEM_NAME,
TB_ITEM_DEPLOY.F_AUTO_ID AS F_AUTO_ID,
TB_ITEM_DEPLOY.F_ORDER AS F_ORDER,TB_ITEM_INFO.F_POINT_CODE AS F_POINT_CODE,
TB_ITEM_INFO.F_CODE1 AS F_CODE1,
TB_ITEM_INFO.F_CODE2 AS F_CODE2,
TB_ITEM_INFO.F_DEPT_CODE AS F_DEPT_CODE,
TB_ITEM_INFO.F_POSITION AS F_POSITION,
TB_ITEM_INFO.F_FLAG AS F_FLAG FROM
TB_ITEM_DEPLOY LEFT OUTER JOIN TB_ITEM_INFO ON
(TB_ITEM_DEPLOY.F_ITEM_CODE = TB_ITEM_INFO.F_ITEM_CODE) and (TB_ITEM_INFO.F_POINT_CODE = '444444') WHERE
(TB_ITEM_DEPLOY.F_MEDIA_CODE1 = '11')---------------------------------------------其中“TB_ITEM_DEPLOY”和“TB_ITEM_DEPLOY”为左外连接查询的两个表的表名。最关键有疑问的地方是:这条SQL语句中,ON条件后面除了通常建立连接查询所需的两表对应字段的条件外,还有一个:“(TB_ITEM_INFO.F_POINT_CODE = '444444')”这样的条件,而且这个条件会对查询结果有很大的影响,请问这个ON后面的条件是什么意思?并且这条SQL语句如何改为Nhibernate使用的SQL语句?
TB_ITEM_INFO.F_POINT_CODE = '444444'是一个条件。。怎么改不清楚。。