SELECT * FROM [dbo].[Product]
WHERE [CategoryID] IN (
SELECT [CategoryID] FROM [dbo].[Category] WHERE [CategoryID] <= 10
)
这段没有看懂,感觉和
SELECT * FROM [dbo].[Product]
WHERE [CategoryID] WHERE [CategoryID] <= 10
是一样的
...全文
2734打赏收藏
Mysql 嵌套查询
SELECT * FROM [dbo].[Product] WHERE [CategoryID] IN ( SELECT [CategoryID] FROM [dbo].[Category] WHERE [CategoryID] <= 10 ) 这段没有看懂,感觉和 SELECT * FROM [dbo].[Product] WHERE [CategoryID] WHERE [CategoryID] <= 10 是一样的