两个表格联合查询问题

[veritasfx]

有两张表格如下：
主表：
bid date slot wait
--------------------------------------
542 2011-10-08 5 101
544 2011-10-08 4 101
548 2011-10-08 4 102
543 2011-10-09 6 102
538 2011-10-09 4 101
539 2011-10-09 5 101
540 2011-10-09 6 101
参考表：
book_date slot
--------------------------
2011-10-08 5
2011-10-08 6
2011-10-08 4
2011-10-09 5

问题：
在主表中选择那些符合参考表中的记录，并选出最小的wait值的那个记录
在以上例子中，有颜色的记录是需要的结果。bid=584的有两记录，只选wait最小值的那个

[--小F--]

bid=584的有两记录?没看见584的

[veritasfx]

[Quote=引用 1 楼 fredrickhu 的回复:]
bid=584的有两记录?没看见584的
[/Quote]
sorry，错了，是548也符合选择条件，但不是wait最小值，所以落选。

[--小F--]

--try
;with f as
(
select 
  *
from 
  主表 a
where 
  exists(select 1 from 参考表 where book_date=a.date and slot=a.slot)
)
select * from f t where wait=(select min(wait) where date=t.date and slot=t.slot)

[veritasfx]

[Quote=引用 3 楼 fredrickhu 的回复:]
SQL code
--try
;with f as
(
select
*
from
主表 a
where
exists(select 1 from 参考表 where book_date=a.date and slot=a.slot)
)
select * from f t where wait=(select min(wait) where date=t.……
[/Quote]
谢谢先，我验证一下。。。

[veritasfx]

[Quote=引用 3 楼 fredrickhu 的回复:]
SQL code
--try
;with f as
(
select
*
from
主表 a
where
exists(select 1 from 参考表 where book_date=a.date and slot=a.slot)
)
select * from f t where wait=(select min(wait) where date=t.……
[/Quote]
这个select 1 是啥意思？我单独执行，选的全部是1啊

[veritasfx]

[Quote=引用 3 楼 fredrickhu 的回复:]
SQL code
--try
;with f as
(
select
*
from
主表 a
where
exists(select 1 from 参考表 where book_date=a.date and slot=a.slot)
)
select * from f t where wait=(select min(wait) where date=t.……
[/Quote]
好像不行，An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.

好像是说最后一句，where 语句不可以嵌套？