Re: Get multiple categories in result set

2003-11-09 Thread Roger Baklund
* Andreas Ahlenstorf > I've got a table with articles and a table with categories. Using a > 'temporary' table it's easy to assign multiple categories to an > article. The insert is no problem, because I can perform two queries, > but for the output I get one row for every every category. But i lik

Get multiple categories in result set

2003-11-09 Thread Andreas Ahlenstorf
Hello, I've got a table with articles and a table with categories. Using a 'temporary' table it's easy to assign multiple categories to an article. The insert is no problem, because I can perform two queries, but for the output I get one row for every every category. But i like to get one row with