通过两个连接加入laravel

Question

I have two connection in laravel, and I want to connect both

I tried like this

$response = DB::connection('connection1')->table('table1 as t1');
$response->DB::connection('connection2')->leftJoin('table2 as t2', 't2.t1_id','=','t2.id')
->get();

But query fails, how to join this, please help.

Just like I can do in mysql like this,

SELECT *
FROM [MyDatabaseOnDB1].[dbo].[MyTable] tab1
INNER JOIN [DB2].[MyDatabaseOnDB2].[dbo].[MyOtherTable] tab2
    ON tab1.ID = tab2.ID

How can do this in laravel.

Please comment, If you give me negative votes please..

Answer 1

To join two different database tables you have to use query builder in laravel 5.2

I think this will help you and working fine in my case.

  $sql="select * from database1.table1 left join database2.table2 on database2.table2.table2Id=database1.table1.table1Id" 
      $data = DB::select($sql);

Hope it will help you...