34,590
社区成员
发帖
与我相关
我的任务
分享
select * from a join b on a.aid=b.aid and a.age>20
select * from a join b on a.aid=b.aid where a.age>20
USE AdventureWorks2012;
GO
SELECT * FROM db_owner.bigProduct A JOIN db_owner.bigProduct B ON A.ProductID = B.ProductID AND A.ListPrice <10.0
SELECT * FROM db_owner.bigProduct A JOIN db_owner.bigProduct B ON A.ProductID = B.ProductID
WHERE A.ListPrice <10.0