select *
from person
where sex="女"
and age<30
and (state="未婚" or (state="离异" and child=0))
and beautiful>95
and riches>1000000
order by age,beautiful
呵呵
同意linly的意见。
不知linly在delphi 的local Sql中是否试过这样的语句
select jhh,sum(sj) as sj,sum(sd) as sd from yjb.db group by jhh,km
having km<>"9999" and km<>"8888"
其中sj，sd为数值字段。我想问的是LOCAL SQL 是否真的支持
select ... from .. group by ...having ..结构。
