query builder with different database, join

Hi, friends!

Example:

Code:

SELECT t1.*, t2.*
FROM database1.table1 AS t1
INNER JOIN database2.table2 AS t2 ON t2.field1 = t2.field1

How i can do this query with query builder in CodeIgniter 3/4 ?

Thanks for answers.

Nobody really knows how to do this?

@gidro,

Try using query binding ( https://codeigniter.com/userguide3/datab...y-bindings ).