get from 2 tables which are connected

[eluser]CroNiX[/eluser]
This isn't really the forum for learning basic MySQL. There are already tons of tutorials covering what you are asking about around the net. Your questions don't really have anything to do with CodeIgniter.

Learn how to use JOIN. Start with joining 2 related tables and work your way up from there. Don't make it overly complex to start or it will probably take a lot longer to comprehend.