2025年鄂冶

鄂冶1 交接样信息表 SELECT t1 jiaoysj t1 jiaoysl t2 saomsj jiaoy t3 bianm t4 name t5 username AS jiaoyry t6 username AS jieyry

大家好,我是讯享网,很高兴认识大家。

1.交接样信息表


讯享网

SELECT [t1].[jiaoysj],[t1].[jiaoysl],[t2].[saomsj_jiaoy],[t3].[bianm],[t4].[name],[t5].[username] AS jiaoyry , [t6].[username] AS jieyry ,[t7].[mingc],[t9].[mingc] AS wullx, [t10].[mingc] AS wul,[t11].[mingc] AS wulpz,[t12].[name] AS zhuzjg FROM [yp_jiaoj] AS t1 LEFT JOIN [yp_jiaoj_mingx] AS [t2] ON [t2].[jiaoj_fk]=[t1].[jiaoj_id] LEFT JOIN [bm_bianm] AS [t3] ON [t3].[bianm_id]=[t2].[bianm_fk] LEFT JOIN [sys_organizs] AS [t4] ON [t4].[organiz_id]=[t1].[organiz_fk] LEFT JOIN [sys_admin_users] AS [t5] ON [t5].[admin_user_id]=[t1].[admin_user_fk_jiaoy] LEFT JOIN [sys_admin_users] AS [t6] ON [t6].[admin_user_id]=[t1].[admin_user_fk_jiey] LEFT JOIN [jc_yangplx] AS [t7] ON [t7].[yangplx_id]=[t3].[yangplx_fk] LEFT JOIN [jl_caig_pic] AS [t8] ON [t8].[caig_pic_id]=[t3].[pic_fk] LEFT JOIN [jc_wul] AS [t9] ON [t9].[wul_id]=[t8].[wul_fk_1] LEFT JOIN [jc_wul] AS [t10]ON [t10].[wul_id]=[t8].[wul_fk_2] LEFT JOIN [jc_wul] AS [t11]ON [t11].[wul_id]=[t8].[wul_fk_3] LEFT JOIN [sys_organizs] AS [t12]ON [t12].[organiz_id]=[t8].[organiz_fk]

讯享网
小讯
上一篇 2025-03-04 21:35
下一篇 2025-04-04 10:43

相关推荐

版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容,请联系我们,一经查实,本站将立刻删除。
如需转载请保留出处:https://51itzy.com/kjqy/131198.html