MSSQL三表/两表联合查询

两张表的联合查询语句

select * from User101219_Expand inner join  user_101445 on User101219_Expand.userid=user_101445.userid

 

三表联合查询语句

select * from User101219_Expand inner join  user_101445 on User101219_Expand.userid=user_101445.userid inner join  FansRole_Commission on user_101445.userid=FansRole_Commission.userid

posted @ 2022-10-28 16:58  Rukh  阅读(59)  评论(0)  编辑  收藏  举报