将查询结果作为另一个查询的条件

[katzel]

onlineT原始数据如下：
shijian paihao total
2010-11-30 11:11:11 1 99
2010-11-30 11:12:11 1 199
2010-11-30 11:13:11 1 299
2010-11-30 13:13:11 5 69
2010-11-30 14:13:11 5 169
2010-11-30 15:13:11 5 269
2010-11-30 15:13:11 5 369

现在有一条语句是查询onlineT表中在2010-11-30这天所生产的牌号,

SELECT  MAX(paihao) AS Expr1 FROM onlineT WHERE (DATEDIFF(day, shijian,'2010-11-30') = 0) AND (total > 100) GROUP BY paihao

查询结果是：
Expr1
1
5



那可以用这个结果做为条件去查询另外一个表不？
recipe 表中的数据：
ID recipeID recipeName
1 1 维维亚诺
1 5 博格诺沃

我需要中文名字的查询结果！

[zoeforever]

SELECT R.recipeName,T.Expr1  FROM recipe R
INNER JOIN
(
SELECT  MAX(paihao) AS Expr1 FROM onlineT T
WHERE (DATEDIFF(day, shijian,'2010-11-30') = 0) AND (total > 100) 
GROUP BY paihao
) T
ON R.recipeID = T.Expr1

[王向飞]

select * from recipe  where recipeID  in 
(SELECT  MAX(paihao) AS Expr1 FROM onlineT WHERE (DATEDIFF(day, shijian,'2010-11-30') = 0) AND (total > 100) GROUP BY paihao
)

[「已注销」]

简单的串表查询。

SELECT * FROM RECIPE  
WHERE RECIPEID  IN 
(
--------你前面的查询sql
	SELECT  MAX(PAIHAO) AS EXPR1 FROM ONLINET
	WHERE (DATEDIFF(DAY, SHIJIAN,'2010-11-30') = 0) 
	AND (TOTAL > 100) GROUP BY PAIHAO
)