mysql 根据一张表中的两个字段拿另外一张表中的同一个字段的查询
selectt1.*,t2. name as driverName,t3. name as managerNameFROMcomprehen_shuttlebuses AS t1INNER JOIN sys_user AS t2 ON t1.driver_id = t2.idINNER JOIN sys_user AS t3 ON t1.manager_id...
·
select t1.*, t2. name as driverName, t3. name as managerName FROM comprehen_shuttlebuses AS t1 INNER JOIN sys_user AS t2 ON t1.driver_id = t2.id INNER JOIN sys_user AS t3 ON t1.manager_id = t3.id 其中comprehen_shuttlebuses表中的driverName和managerName对应的是sys_user表中的name.
更多推荐
已为社区贡献1条内容
所有评论(0)