Multiple Attribute Queries
The previous examples show how to create expressions for single predicates. The
Amazon SimpleDB query language also supports constructing expressions across multiple predicates
Multiple attribute queries work by producing a set of item names from each predicate and
intersection operator. The intersection operator only
returns item names that appear in both result sets.
This section shows multiple attribute queries and their results.
To view the source data for the queries, see Sample Query Data Set.
The following table shows some multiple attribute queries, how they are interpreted, and the results they return from the sample dataset.
Retrieves all items that have a "****" Rating.
Retrieves all items that only have a "****" Rating. Items are not returned that have a multi-valued Rating attribute that contains any value other than '****.'
Retrieves all items that have a "Book" Keyword and a "Hardcover" Keyword.
The first predicate produces 0385333498, 0802131786, and 1579124585. The second produces 1579124585. The intersection operator returns results that appear in both queries.