mysql - mysql中的内连接

Question

SELECT FirstName from tbl_User INNER JOIN tbl_Organisation  
on tbl_user.tbl_organisation_OrganisationID=tbl_Organisation.OrganisationID      
  WHERE tbl_organisation_OrganisationID = '23'

我想从 tbl_Organisation 获取一个列(OrgName)。我怎样才能用上面的代码做到这一点。

Answer 1

只需:

SELECT tu.FirstName, tor.OrgName from tbl_User tu INNER JOIN tbl_Organisation tor
on tbl_user.tbl_organisation_OrganisationID=tbl_Organisation.OrganisationID      
WHERE tbl_organisation_OrganisationID = '23'