SQL内联多个表

最新推荐文章于 2023-11-17 16:31:35 发布

weixin_30764771

最新推荐文章于 2023-11-17 16:31:35 发布

阅读量357

点赞数

原文链接：http://www.cnblogs.com/yechangzhong-826217795/p/5683807.html

版权

SQL多个表组合成一个表：

            strSql.Append(@"Select N.NotificationOptionId,
                                   S.FullName,
                                   No.Title,
                                   N.SortCode,
                                   N.Content,
                                   N.CreateDate,
                                   N.CreateUserId,
                                   N.CreateUserName,
                                   N.ModifyDate,
                                   N.ModifyUserId,
                                   N.ModifyUserName                                  
                              From (NotificationOption As N
                                   Inner Join Sys_Company AS S On S.CompanyId=N.SchoolCode)
                                   Inner Join Notifications AS No On No.NotificationId=N.NotificationId
                                   Where 1=1");

转载于:https://www.cnblogs.com/yechangzhong-826217795/p/5683807.html