Tomas Karlsson wrote:
> I have a table with these fields: name, cat1,cat2,cat3, where cat1-3 refers to a job
> category (one record per name). I am trying to figure out how to write the SELECT
> statement so that if the person has filled out more than one category that would
> in more than one row by SELECT. For instance, if cat1,cat2 and cat3 all have values
> (not NULL) for a certain name, that would give me 3 rows that I then can sort with
> SELECT. Am I wrong assuming that a single SELECT can return more than one row
> per record?
> Thanks in advance!
The best solution in your situation is to bring your table to the third
normal form. I cannot tell you very much detail, because cat1-3 is is
the only thing I know about your table. The idea is that you should
design your table is such a way that if one person has a relationship
with more than one category, you would have a row per category. You
should probably have a separate person_cat table, and join it with the
main one when needed.