1. In
select * from t_book tb where tb.bookTypeId in (select id from t_bookType tbt);
select * from t_book tb where tb.bookTypeId not in (select id from t_bookType tbt);
2. Compare > < ...
select * from t_book tb where tb.price>=(select price from t_pricelevel where priceLevel=1);
3. Exists
select * from t_book where exists (select * from t_bookType);
select * from t_book where not exists (select * from t_bookType);
4. Any
select * from t_book where price >= any (select price from t_pricelevel);
5. All
select * from t_book where price >= all (select price from t_pricelevel);