摘要： 1交叉联接 cross join 笛卡尔积 将一个表的每行与另一个表的所有行进行匹配 m行表与n行表cross join 得到m*n行的结果集--ANSI SQL-92标准 CROSS JOIN 关键字SELECT c.custid , e.empidFROM Sales.Customers AS c CROSS JOIN hr.Employees AS e--ANSI SQL-89标准SELECT c.custid , e.empidFROM Sales.Customers AS c , hr.Employees AS... 阅读全文