Can I have 2 tables in codeigniter 4 model?

This shows you how it is done.

stackoverflow -> Codeigniter 4 query builder join 2 or more tables without duplicate result

Great thank you

Kindly , what about using a RAW query inside the model making that join?
I mean , just to understand the mechanic, how would be achieved to access many tables of the same db for those joins?

Thank you and thank you for the link