Brackets and boolean operators can be used to construct complex queries, e.g.
TTL:apple AND (ABST:banana OR ABST:orange) NOT ABST:pear

Selecting a single database will give access to field codes specific to that database. Common search codes can be searched across all databases.