Can I have 2 tables in codeigniter 4 model?

Use CodeIgniter 4 QueryBuilder class and joins on the different tables.

Hello thank you

I was reading that section of the guide

So you confirm it is possible to join different tables at the Model level using the query builder methods

and this task can be accomplished inside the Model
Right?

Entity Classes may be an alternative or they make no sense in the case of my question? Thank you hinting

And , still for learning, third option: aiming to write the RAW query. Wanting to use the RAW query, how do I access the others tables in this model? I tried but I get errors because the others tables looks like not found.

R