作者kyshiao (天气真好阿)
看板Database
标题[SQL ] 请问一下某段SQL UNION/JOIN的执行顺序
时间Wed Sep 21 12:01:44 2011
SELECT A1 FROM A
UNION ALL
SELECT A2 FROM A
INNER JOIN B ON A1=B1
请问这段SQL会先执行UNION ALL再执行INNER JOIN
或者是
先执行SELECT A2 FROM A INNER JOIN B ON A1=B1再执行UNION ALL?
谢谢
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 211.75.136.25