逗号连接查询(用where连接条件):
select order.id, order.orderdate,employee.id,employee.name from order,employee where order.empid=employee.id
等价于inner join查询:
select o.id, o.orderdate,e.id,e.name from order o inner join employee e on o.empid=e.id
逗号连接查询(用where连接条件):
select order.id, order.orderdate,employee.id,employee.name from order,employee where order.empid=employee.id
等价于inner join查询:
select o.id, o.orderdate,e.id,e.name from order o inner join employee e on o.empid=e.id
转载于:https://www.cnblogs.com/aaronhoo/p/8876574.html