Hello,

I hope the title says more or less what I would like to achieve. For a better overview I've made two screenshots.

That's the given structure (3 tables):
http://www.pic-upload.de/view-24012442/01_given_structure.png.html


And that's what I would like to have as result, to be able to select from it:
http://www.pic-upload.de/view-24012443/02_result.png.html

I'm at the point to think that it only can be achieved by a stored procedure (if at all), but somehow I struggle to figure out, how to do it with 3 tables...

Any hint into the right direction would be highly appreciated.

Best regards,

Patrick