I have two tables 1 containing purchase order no and 1 containing the items purchased.(they are related with the purchase order no.)
I need to concatenate the Purhcase order and all the items purchased into 1 line.
each item will have an identifier to determine where the new item starts
so that it looks like this
I read about fetch next but I can do not know how to set this up..
Can anyone provide a sample on how I can accomplish this?