oracle数据库中多条件查询语句怎么写？

select a,b,c,....... from t1,t2 where t1.a=t2.b and t1.d !="" and t2.c='***' and.....