Question

access数据库中查询条件不为空,怎么写

select * from table where 条件

Answer 1

想取得全部数据写：select * from table where 1=1 想取得空集就写：select * from table where1=2

Answer 2

select * from table where Field!=""

Field(字段)