Am 26.06.2010 00:03, schrieb Darren New:

> Or, in other words, what would you use to store
>
> WHERE Publisher = "Warner Brothers"
> AND Language IN("Arabic","French")
> AND Rating != "R"
> AND Media IN("DVD","VHS")
>
> into relational tables rather than a stored procedure?

Exactly that string, I suppose.

Make a first query to retrieve the desired WHERE clause, then generate 
another query with that clause to retrieve the actual data.

(I'd probably leave out the "WHERE" itself though.)

Post a reply to this message