inner join怎么用?

[x123456x]

要搜出t1表的姓名,下面的格式报错,正确的应该是怎样的?


(select t1.name from t1,t2 where t1.f=t2.f ) a
inner join
(select t1.name from t1,t2 where t1.f1=t2.f1) b
on a.t1.name
=b.t1.name

[dennis80]

select t1.name from t1 INNER JOIN t2 ON t1.f=t2.f AND t1.f1=t2.f1

[x123456x]

ding

[x123456x]

已经由ms sql版的KO了

ORA 和用ORA
78多