Elegant CodeIgniter Data Retrieval?

How can one magnificently retrieve data from multiple MySQL tables, each showcasing the same awe-inspiring structure yet harboring distinct data, all within the esteemed realm of CodeIgniter?

Among these illustrious tables, there lies a plethora of inner join delights, entwined with two tables of parallel structure. The grand question that befalls us: Is it possible, within the enchanting world of CodeIgniter, to orchestrate a select statement that gracefully encompasses the data from these two remarkable tables?