Re: Was: Triggers, Stored Procedures, PHP

Shane D <shane(dot)dawalt(at)wright(dot)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