此句中
SELECT min(a.x-b.x) as shortest
FROM point as a,point as b
WHERE a.x-b.x>0;
等于
SELECT min(a.x-b.x) as shortest
FROM point as a cross join point as b
WHERE a.x-b.x>0;
此句中
SELECT min(a.x-b.x) as shortest
FROM point as a,point as b
WHERE a.x-b.x>0;
等于
SELECT min(a.x-b.x) as shortest
FROM point as a cross join point as b
WHERE a.x-b.x>0;
本文标题：cross join
本文链接：https://www.haomeiwen.com/subject/pgqzrctx.html
网友评论