SQL语句 (A Left Outer join B On) Where A.Fld *= B.Fld

1
insert into atest  values( '00009','GPF',26,100,100,120,'')

insert into atest2
select * from atest where id = 00002

insert into atest2 ( id, age,name )
select id, age,name from atest where id = 00009

2
select cardno, avg(grade) as avg
from agrade where cardno = 0102
group by cardno
having avg(grade) > 0

select cardno, max(grade) as avg
from agrade where cardno = 0102
group by cardno
having max(grade) >70

select cardno, max(grade) as avg
from agrade
group by cardno
having avg(grade) >70

select top 1 cardno, avg(grade) as AVG
from agrade
group by cardno
having avg(grade) <70 order by avg(grade) desc

3
select *
from agrade a
where exists
(
select * from aclass b where b.class =009 and a.cardno = 0101
)

4
select *
from agrade a left outer join aclass b on
a.biko = b.teacher where a.cardno = 0101

5 左外Link（*=）
select a.*, b.name as Class, c.memo as Sex from
astudent a, aclass b, asex c
where a.sex *= c.sex and
　　　a.class *= b.class
and a.age > 30