Shane D <shane.dawalt@wright.edu> writes:
> But what if the films table also had a field for the production
> company. This implies based on the view definition that it too, has
> the field (call it prod_co). Could I use the following query to
> select all Comedy films distributed by the 'Small Company' production
> company?
>
> SELECT * FROM kinds WHERE prod_co = 'Small Company';
Sure, as long as the column is part of the view, you can use it to
constrain the SELECT.
-Doug