Firstly, welcome aboard FT.

At the very top of this forum, you'll find a "sticky" entitled Useful Star Alliance References/Links or along those lines. All manner of great information on the Alliance and it's partners contained in that.

Bjornstrom's post contains most of what you need to know in relation to your specific question, but there are some quirks he/she didn't mention, such as AC books into H for the 1/2/3 products and other oddities like some carriers using Y for domestic flights etc.