Sql Server 中交集查询问题

[Hyacinthus]

Oracle 中的intersect （交集） 在Sql Server 中用什么代替？

比如
select max(fa_order) ma,fl_id from t_Flowaudit group by fl_id
得到结果为
ma fl_id
3 15
3 42
2 48
1 49
4 51
五条记录

select fa_order ma, fl_id from t_Flowaudit where us_id=98
得到结果为
ma fl_id
2 42
2 48
4 51
三条记录

我要的是在所得的两个数据集中都存在的记录（交集）， 即：
要得到结果应该为
ma fl_id
2 48
4 51
两条记录

在Oracle 中可以如下得到
select fa_order ma, fl_id from t_Flowaudit where us_id=98
intersect
select max(fa_order) ma,fl_id from t_Flowaudit group by fl_id

在Sql Server中如何实现同样的功能？？？？
用 EXISTS 查询出来的结果是不对的，

[CSDNM]

select a.* from
(
select fa_order ma, fl_id from t_Flowaudit where us_id=98
) as a,
(
select max(fa_order) ma,fl_id from t_Flowaudit group by fl_id
) as b
where a.ma=b.ma and a.fl_id=b.fl_id

[蓝天]

select a.ma,a.f1_id from (select max(fa_order) ma,fl_id from t_Flowaudit group by fl_id ) a ,t_Flowaudit b where a.ma=b.fa_order and a.fl_id =b.fl_id and b.us_id=98

[CSDNM]

exists:

select * from
(
select fa_order ma, fl_id from t_Flowaudit where us_id=98
) as a
where exists (
select 1 from
(
select max(fa_order) ma,fl_id from t_Flowaudit group by fl_id
) as b
where a.ma=b.ma and a.fl_id=b.fl_id
)

[Anstinus]

这样不行吗
select fa_order ma, fl_id from t_Flowaudit where us_id=98 and exists (
select max(fa_order) ma,fl_id from t_Flowaudit t1 where t1.ma = t_Flowaudit.ma and t1.fl_id = t_Flowaudit.flid group by fl_id )

[Hyacinthus]

呵呵， 谢谢各位！！