Ò»ÌõSQLÓï¾ä

Á½¸ö±í£º
TEST1:
A          B      C
F0 2009-9-1   2
F0 2009-9-2   2
F0 2009-9-4   2
F6 2009-9-1   3
TEST2:
D          E      F
F0 2009-9-1  4
F0 2009-9-3   4
F0 2009-9-4   4
F6 2009-9-2   5
ÐèÒªËã³öA=DºÍB=EµÄC*F
³öÀ´½á¹û£º
F0 2009-9-1   8
F0 2009-9-2   2
F0 2009-9-3   4
F0 2009-9-4   8
F6 2009-9-1   3
F6 2009-9-2   5

---

select a.a,a.b,a.c*b.f from test1 a,test2 b
where a.a=b.d and a.b=b.e

---

SQL code:
select A,C*F from test1,test2 where A=D and B=E

ÊÇÕâÒâ˼£¿

---

SQL code:
select test1.a,test1.b,test1.c*test2.f from
test1 inner join test2
on test1.a=test2.d and test1.b=test2.e

---

          select *,test1.c*test2.f as a from test1,test2 where test1.a=test2.d and test1.b=test2.e

---

SQL code:
select
isnull(a,d) as ad
,isnull(b,e) as be
,isnull(c,1)*isnull(f,1) a