How to compare two tables and insert the match data in another table

In order to join two tables, you need a foreign key in second table. I am considering pincode is the foreign key.

In this case, we can do that in few ways.

• Relationships
• Join Tables

Relationships

In table1 model.

public function table2()
    {
        return $this->hasOne('App\Table2', 'pincode');
    }

In table2 model.

public function table1()
    {
        return $this->belongsTo('App\Table1', 'pincode');
    }

Now you can access based on relationships. Ref: https://laravel.com/docs/5.4/eloquent-relationships#one-to-one

Join Tables

In this case, you can join two tables-

DB::table('table1')
            ->join('table2', 'table1.pincode', '=', 'table2.pincode')
            ->select('table1.*', 'table2.*')
            ->get();

Ref: https://laravel.com/docs/5.4/queries#joins

In the table2 also have "id" in the table and then how can i compare match data and then insert the match data in another table called "table3"

Than simply just follow this concept-

$users = DB::table('users')
            ->join('contacts', 'users.id', '=', 'contacts.user_id')
            ->join('orders', 'users.id', '=', 'orders.user_id')
            ->select('users.*', 'contacts.phone', 'orders.price')
            ->get();

Ref: https://laravel.com/docs/5.4/queries#joins

My question is compare the two tables and find the match data and then insert into another newtable.

Somehow I am tryon to do the same

Can some tell me how to call this code in the view?