|
![](/i/fill.gif) |
SharkD wrote:
> Something like that. Also, Google "SQL JOIN" if your data is spread
> across multiple tables.
Err, no. The point of my question was that I don't know it's ratings,
publishers, etc. All I know is that there are tags.
Think of (say) ID3 tags, or arbitrary user tags. I know how to store that in
SQL. I want to know how to make arbitrary queries against the data. Or,
rather, how best to represent arbitrary queries.
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?
--
Darren New, San Diego CA, USA (PST)
C# - a language whose greatest drawback
is that it's best implementation comes
from a company that doesn't hate Microsoft.
Post a reply to this message
|
![](/i/fill.gif) |