MySQL:如何对现有记录集执行查询？

Question

我想对现有记录集执行 SELECT 查询，例如:

query1 = 'Select * from products where onSale = 1'

然后

query2 = 'Select * from recordset1 where ....'

其中 recordset1 是 query1 返回的行数。有什么建议么？谢谢!

Answer 1

使用子查询:

SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2);