I'm searching for two days now a piece of code on the web which looks like what I discribed earlier.

Usually when I can't find an answer to something via a google search it is because I haven't defined the search parameters correctly. If I understand correctly what you are trying to do is either a view or a join (or both.)

What you haven't defined in describing your problem is what database you are doing this against as different databases have different implementations to work with.

• If join is what you are after check out (offsite) understanding joins
• If views are what you are after check out (offsite) mysql views tutorial

As far as DBI there are copius tutorials around the web. The rest is all about SQL syntax