select * from A_tabl a where a.status like ?
and a.trdate between ? and ? and(a.name like ? or a.id in(select id from B_tbl where clid like ?) or a.id2 in (select id from B_tbl where clid like ?))
order by clid,trdate desc;
说明:查询同时满足a.status,a.trdate 以及满足a.id 或者a.id2的条件的所有数据,涉及到分页请用hibernate或者自己根据选择数据库添加分页语句。
2013-12-18