> That would be in violation of the SQL spec. The query is defined to
> return each join row from the cross product of the FROM tables that
> meets the condition of the WHERE clause. As you wrote the query, each
> metadata row that meets the WHERE clause will be returned exactly as
> many times as there are rows in the images table. There is no such
> thing as an "unreferenced" FROM entry as far as SQL is concerned.
Sounds about right. Thanks for the clarification.
Peter