|
![](/i/fill.gif) |
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
|
![](/i/fill.gif) |