Pattern matching with an OR relationship
In the previous section we saw that if there are two pattern matching conditions, they have an AND relation – the query will return only those items that match both patterns. If we want to have an OR relation between the conditions, we use the UNION operator. The following query retrieves items that are either part of the Star Wars film series or part of the Star Trek film series.