SELECT * FROM a, b
WHERE a.orderid=b.orderid

SELECT * FROM a JOIN b
on a.orderid=b.orderid

什么区别，哪个效率更高？
谢谢！