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