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 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 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
