sql求写法

sql求写法
表１：
字段名:f1 f2
      1  b1
      2  b2
      3  b3
表2:
字段名:f1 f2 f3
      1  c1  1
      1  c2  2
      2  c3  1
我想两张表通过f1字段连成如下效果
1 b1 c2  2
2 b2 c3  1
3 b3 null null     

---

SQL code:
select a.*,b.f2,b.f3 from 表1 a left join 表2 b on a.f1=b.f1

---

SQL code:
select t1.*,t2.f2,t2.f3
from t1
left join t2 on t1.f1=t2.f1

---

没看明白什么关系

---

SQL code:
select * from 表１ as a,表2 as b where a.f1=b.f1

---

SQL code:
select isnull(m.f1,n.f1) f1 , n.f2 , n.f3 from tb1 m left join
(select t.* from tb2 t where f3 = (select max(f3) from tb2 where f1 = t.f1)) n
on m.f1 = n.f1

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlig