Re: Query to combine two 'many:one' tables

First case: Either you write dynamic SQL (because you don´t know how many cases will be the maximum for one Client), or you use the script from this article

http://groups.google.de/groups?q=%22A,B,C%22+%22D,E,F%22&start=10&hl=de&lr=& ie=UTF-8&oe=UTF-8&scoring=d&selm=e9tnQHVbDHA.2136%40TK2MSFTNGP10.phx.gbl&rnu m=14

it had the same problem described like you did.

HTH, Jens Süßmeyer. Received on Fri Aug 29 2003 - 15:57:11 CEST