建视图时，让重复的数据只显示一次？

[shuihan16]

table1中数据:
A B
C001 1
C002 0
C003 0
C004 0
C005 1
C007 1
C009 0

table2中的数据：
A E FLG
C001 F01 1
C001 F02 1
C001 F05 2
C002 E00 1
C002 E02 2

我要取table中的B列值为 1 的数据，table2中FLG的数据，和A列的数据，而且A重复的记录只显示一次。
这个视图要怎么建呢？

想了好久 ，实在想不出来。

[SQL77]

CREATE VIEW VIEWNAME
AS 
  SELECT DISTICNT A.B,B.A FROM TABLE1 A,TABLE2 B WHERE A.A=B.A AND A.B=1

?

[SQL77]

CREATE VIEW VIEWNAME
AS 
  SELECT DISTINCT A.B,B.A FROM TABLE1 A,TABLE2 B WHERE A.A=B.A AND A.B=1

[bancxc]

select Distinct Table1.A,Table1.B,Table2.Flg
from table1
inner join table2 on table1.A=table2.A