mysql内连贯怎么写
发布时间:09/01 来源:未知 浏览:
关键词:
内连接定义:仅将两个表中知足连接前提的行组合起来作为结果集。
关键词:INNER JOIN
select * from employees e inner join department d on e.employee_id = d.department_id where e.employee_id = "1";
等价于
select * from employees e,department d where e.employee_id = d.department_id and e.employee_id = "1";
以上就是mysql内连接如何写的具体内容,更多请关注百分百源码网其它相关文章!