两个表
tb_user_team
ID UserID RoleID TeamID
...tb_team
ID TeamID TeamName
...我现在想通过UserID查询得到一个TeamID和TeamName构成的表即:
TeamID TeamName两列SQL语句如何写啊?
谢谢!
tb_user_team
ID UserID RoleID TeamID
...tb_team
ID TeamID TeamName
...我现在想通过UserID查询得到一个TeamID和TeamName构成的表即:
TeamID TeamName两列SQL语句如何写啊?
谢谢!
FROM tb_user_team AS A
JOIN tb_team AS B
ON A.TeamID=B.TeamID
FROM tb_user_team AS A
JOIN tb_team AS B
ON A.TeamID=B.TeamID
WHERE A.UserID=xxx