join multiple tables in laravel eloquent

Solutions on MaxInterview for join multiple tables in laravel eloquent by the best coders in the world

showing results for - "join multiple tables in laravel eloquent"
Christi
17 Feb 2019
1use Illuminate\Support\Facades\DB;
2
3$users = DB::table('users')
4            ->join('contacts', 'users.id', '=', 'contacts.user_id')
5            ->join('orders', 'users.id', '=', 'orders.user_id')
6            ->select('users.*', 'contacts.phone', 'orders.price')
7            ->get();
Anna
12 Apr 2016
1$users = User::join('posts', 'posts.user_id', '=', 'users.id')
2            ->where('users.status', 'active')
3            ->where('posts.status','active')
4            ->get(['users.*', 'posts.descrption']);
Lilly
24 May 2018
1$users = User::join('posts', 'posts.user_id', '=', 'users.id')
2            ->where('users.status', 'active')
3            ->where('posts.status','active')
4            ->get(['users.*', 'posts.descrption']);
5
Lettie
04 Oct 2019
1 $select->joinSub(
2                    $selectSubQry,
3                    'ag',
4                    'ag.id',
5                    '=',
6                    'agp.userId'
7                );
queries leading to this page
how to join another table via with in laravellaravel where join eloquentinner join in laravel 8laravel left join two tables where conditionslaravel query builder left joinselect from 2 table with join in laravelmerge three tables in laravel eloquentlaravel data table with joinlaravel how to do join eloquenteloquent query builder joinjoin eloquent laravel 7 syntaxlaravel table join three tables dbcomplete join query in laravel 8laravel join different tables depending on valuelaravel join another database tablelaravel eloquent left join multiplelaravel join multiple tableshow to join multiple tables with eloquent relationshipslaravel join with two columnslaravel select join tablelaravel mysql join with joined tablelaravel query bulder joinjoin 2 tables in laravellaravel 8 eloquent multiple joinsselect join query laraveljoin tables with eloquent laravellaravel eloquent join 2 tableshow to two table join in laravellaravel join two tablelaravel db double join query inside joinlaravel query joinlaravel mongodb query builder joinlaravel 8 query builder with joinsjoinsub laravel outer joinjoin 2 table on different connection in laravel join beetwen 2 tables in laravel query how to join tables in eloquentjoin in 2 tables in lartavel laravel model join query 24builder 3ejoin in laravellaravel inner join three tables3 table join in laraveltwo tables join in laravel 8 join multiple tables in laravel eloquentlaravel elequent and in joindb 3a 3atable join laravellaravel join 3 tablesjoin 2 eloquent querylaravel join tablesjoin two tables and get all records laravellaravel eloquent join with multiple key conditionslaravel eloquent subquery joinlaravel join table on itselfjoin multiple table using eloquent model in laravellaravel db join based on two column laravel db query join with one to manylaravel eloquent query inner joinjoin 3 tables laravelhow to join multiple tables using laravel relationsjoin two tables and get all records in laravellaravel eloquent join on multiple columnsinert join laraveljoin table with 3 columns laravelsite 3alaravel com 2fdocs orm join querylaravel merge 2 query resultsjoin laravel with other tableslaravel inner join with multiple conditionsmultiple table join laravellaravel same table joinlaravel mysql join 2 tables latest create datahow to use and in condition join query builder laravellaravel two table join queryjoin 5 tables in eloquent laravellaravel multi joinhow to join 5 tables in laravelhow to use join from two different databse table in laravellaravel eloquent join 2 tablehow to multiple table connect laraveljoin three table in laravel eloquentjoin laravellaravel 2b join 2 eloquent querieshow to join multiple tables with eloquent relationships in laravellaravel multiple database joineloquent query builder inner join andlaravel join 2 tables using modelhow to join 3 table in laravellaravel join tablelaravel join query using modellaravel multiple table join querylaravel eloquent subquery select join concatenate6 mysql table join in laraveljoin another any join in laravel 8multiple tables join in laravelmultiple join in with in laravel modellaravel left join exampleslaravel query join two rowsjoing three tables query builder laravel2 joins on different tables in laraveljoin two tables laraveljoin two table from different database connection in laraveljoins and where table in laraveleloquent join with wherelaravel eloquent join on two columnslaravel join two tables using wherelaravel left join with multiple conditionsin where query join table in laravellaravel eloquent join three tablesjoin multiple model laravellaravel eloquent join with andjoin multiple tables without mysql join laravelinsert data of join tables in laraveljoin tables laravellaravel join two tables from different connectionshow to join two tables in laravellaravel join in callbacklaravel inner join queryphp laravel sql join two tablelaravel query join with relationhow to use multiple join in laravellaravel update with joinlaravel equivalent select multiple column joinjoin two tables in laravel 8 inlaravel join 2 tables in model collectionjoin two tables with where clause laravel querylaravel sql inner joinhow to write join query in laravel modellaravel multiple join same tablewherein in whereraw in laravellaravel left join multiple conditionslaravel left join query example2 join in laraveljoin two queries laraveljoin 2 models laravellaravel join 2 tables exampleget data with join tables laravelhow to join three tables in sql laravellaravel join two tables with same column datalaravel query builder whererawlaravel multiple raw query join laravel selectraweloquent multiple inner join onjoin two tables in different databases sql laraveljoin table on 2 database connection laravel laravel do a join instead of model builderjoin in laravel eloquenteloquent join relationshipjoinsub to join 2 queries in laraveljoin more table by db query laravellaravel querybuilder data joinquery builder join laraveljoin several tables laraveltwo tables join laraveljoin multiple tables in laravel 8 laravel join two tables with two fieldsjoin table laravellaravel eloquent conditional joinjoin with model in laravel from two different database tablejoin tow tables laravelwhere in dbraw in laraveljoin querybuild laraveldb connection join two table in laravellaravel multiple table join tablelaravel join table with itselfjoin between two tables larav ellaravel join with 2 conditionlravel eloquent joinlaravel join different table from querylarave eloquent join two different databasejoin two table in laravel using where conditionall join in query builder laravelhow to join one to one in laravel modelhow to join two tables from different database in mysql 2b laravellaravel eloquent builder 3a 3a join onlaravel join 2 tables query orwherehow join and having work ina laravelwhereraw laravellaravel eloquent query joinhow to join two table by laravel eloquent modeltwo joins laravellaravel join query from model eloquentlaravel inverse inner joinjoin 3 tables in laraveljoin laravel on string columnsmodel join laravellaravel db multiple columns to joinjoin in laravellaravel eloquent join with conditionjoin three tables laravellaravel 2 table joining and orwhereappend from join laraveljoin multiple columns laravel with same datahow to join 2 queries with eloquent3 table join with select in laravel querymultiple join query via as in laravelselect as after join laravellaravel join on 2 columnslaravel join querymultiple join in laravellaravel left joinlaravel model query joinlaravel join table with two other tables on two columnsmodel with join laravellaravel join 2 tables query builderlaravel querybuilder joindb table query laravel two table joinlaravel 8 join tablesinner join query in laravel eloquenthow to get inner join 2 tables in laraveljoin query with where condition in laravel 8inner join 3 table in database table laraveljoin laravel function for 2 tableslaravel multiple join conditionslaravel raw join queryhow to merge two query result in laraveldb 3a 3atable add join in laravelhow to join two tables with different name in laravellaravel join with sub data multiple recordeloquent query builder inner joinlaravel eloquent join two tables with relationshipjoin in same table laravel 8laravel select from multiple tables without joinjoining two tables in laravel and mysqlsearch from multiple tables using join query in laravelwhereraw in laraveljoin table select all table laraveljoin many tables in laravellaravel query builder join results in arraylaravel join on two conditionsjoin table in laravel controllerjoining tables laraveljoin two elquent resultlaravel join query with conditioneloquent join examplejoin in laravel eloquent from 4 tableshow to join two models laravel queryhow to join two tables in laravel modeljoins of two tables in laraveleloquent merge querieslaravel query builder hwhere joinlaravel join on two columnslaravel join and concat two columnsjoin multiple query in laravellaravel link two tableslaravel join two tables querywhat is a left join in laravellaravel multiple update queryes with one connectionjoin two tables in laravellaravel 2b docs 2b joineloquent laravel join 2 columjoin two table in relationship in laravellaravel eloquent join multiple conditionsjoin 2 database laravellaravel eloquent query builder join two columns between two tableslaravel 8 join 3 tableshow to join tables in laravel eloquenttwo table join query laravellaravel join 2 tables eloquentselect join table data in laravel modeleloquent model join queryjoin 3 or more tables in laravel using dbeloquent query multiple tables join in laravellaravel left join with multiple recordlaravel data table joineloquent laravel query joinselect join in laraveljoin two tables in eloquent laravellaravel 8 join table eloquenteloquent subquery joinlaravel join two table from different databasequery result after join statement in laravel laravel join query from eloquentlaravel join two query resultstwo table join query in laravel using elpquentlaravel db inner joinlaravel eloquent query with joinjoin of 2 tables in laravellaravel join two resultslaravel join two tables with same column namelaravel join multiple conditionshow to join table in oem in laraveljoins two table in laravelhow to join another table via joinand fetich in laravel elequent model join queymultiple join laravelhow to use join in laravel 8 using query builderlaravel join eloquentlaravel left join 3 tables join tow laravel and wherelaravel join on multiple conditionslaravel orm inner joineloquent join on rawhow to add multiple condition on join query laravellaravel join multiple recordslaravel join with multiple conditionslaravel join with two wherelaravel right joinhow to join two tables in laravel using eloquentlaravel mysql inner join queryjoin three tables in laravellaravel join with multiple conditionshow to join 2 collection tables together laravelhow to join tables in select on laravel using eloquent subquerylaravel left join multiple tablespass two table name in join in laraveljoin table select in eloquentlaravel join query with relationshipjoin table mysql laraveljoin in laravel controllerlaravel joint querylaravel making many queries instead join relationshipjoin two tables in laravel eloquenthow to join three table in laraveleloquent join withlaravel havingrawlaravel 8 join two tablesjoin 2 table in laravellaravel eloquent table join with use the two table relationshipmodel join query in laravelhow to join one table with two different tables in laraveleloquent get joined tableslaravel 8 left join with multiple conditionseloquent with and joinlaravel join on multiplecan we use with 28 29 in join query in laraveljoin multiple tables in mysql laraveljoin select multiple row laravellaravel query builder join multiple conditionslaravel eloquent multiple joinlaravel join two tables using modellaravel joinsmultiple table join query in laravellaravel query join conditionlaravel db table joinlaravel join two through tablejoin 2 tables on laravelinner join eloquentlaravel query in multiple tablehow to join with the joined table in laraveleloquent inner joinlaravel join table with one rowlaravel db join select all of two tablesmake join table in laravel eloquent join query in eloquent laravelcan we use multiple inner join in laravelhow to join multiple queries in one query laraveljoin two tables laravel controllerinner join laravel query buildertinker how to join two tables laraveljoin with 2 tables in laravel eleqountjoin more than 5 tables in laravelhow to store join table in laravel 7insert join laraveldb table join laravelhow to join two tables in laravel query builderlaravel eloquent join two tablesjoin on and on laravel query builderjoining 5 tables in laraveljoin inside with clause laravelleft join in laravel querytable join database for get data in eloquent laravellaravel eloquent join two modelshow to join two tables in laravel 8 laravel join orcombine two eloquent queries laraveljoin three tables in php laraveljoin tables in laraceleloquent join several tableseloquent with join laraveljoin 2 tables laravelmerge 2 query results laravellaravel 8 left join in multiple tablelaravel join two tables wherejoin 3 tabels in laravelhow to join table in laravel eloquentjoin three tables or more in laravel eloquentlaravel eloquent inner joinhow to join two tables in mysql in laravellaravel model method in row query with joinjoin with two conditions in laravelhow to join 2 db tables laravelhow to join three tables in laravellaravel query builder join subquerylaravel join with modellaravel whererawleft join on multiple columns eloquentjoin with condition eloquentlavravel joinlaravel join two tables by orlaravel make 2 query en join resultsmysql left join two queries laravel eloquentjoin three tables in laravel eloquentlaravel join more than 3join query in laravel with and conditionjoin two tables with condition in laravel eloquentlaravel db multiple join onlaravel eloquent join ueryleft join in laraveljoin on equivalent eloquent laraveltwo join laraveljoin tow laraveljoin table with different columns laravelquery for one master table join 2 details tables laraveljoin twotable in laravel using eloquentget join 2 value laravellaravel 8 joins two tablesjoin tables in laraveluse left join in laraveleloquent 2 model joinusing as in join query builder laravellaravel database join in joinlaravel using where with whererawlaravel join 2 tables queryjoin multiple tables in laravel with in one model wherein with whereraw in laravellaravel 3ejoinmultiple condition on join laraveljoin 2 table on different database connection in laraveljoin two table using model in laravel 8how to join 2 tables eloquenteloquent join query with where condition laravelmultiple in join laravelquery builder join 2 tables in laravelmultiple tables join laravellaravel eloquent select with joinnesting query join results laravel query builderjoin query in laravel datatableslaravel query builder left join selector whereraw laraveljoin query in laravellaravel mysql join tablelaravel model join 2 tables where ininner join db laravelmultiple table connect in laraveljoins in laravellaravel 7 join two tableslaravel eloquent multiple queries in one connecitonlaravel join two tables where get one idlaravle three table join queryeloquent join on relationshiplaravel db query join functionjoin eloquent laraveleloquent query builder join in where clauseuse conditions in eloquent join multiplemultiple condition in join laravelusing join query in two tables in laravel 8 itsolutions examplelaravle selct join querylaravel eloquent join 3 tables wherelaravel join table eloquentjoin multiple table and loop by a particular table in laravelmultiple left join in laraveljoin condition in query builder laravellarave join on andlaravel right join querylaravel add two joins laravel eloquent query join with selectjoin tow where laravelmerge two different query result laraveljoining tables in laravel 8laravel how to join 2 wherejoin 2 table in laravel 8wherein and whereraw in laravellaravel join 4 tableslaravel query builder join two tablelaravel join donot include joined tableupdate by join two tables laravellaravel join two tablesfunctiondb join laraveljoin on multiple columns sql laravellaravel join with table from different databaseloquent join two tableslaravel mysql join 2 tables latest datalaravel merge two query resultsjoin en laravel eloquentjoin multiple table in laravelhow to create import two table join in laravel 7multiple join condition in laravel 8join use two condition in laraveljoin in laravel 8left join laravellaravel joineloquent query select multiple tableslaravel query builder joinlaravel join 2 tables where orwhere join query builder laravellaravel multiple records join conditionslaravel join multiple databaselaravel 8 select inner jointwo table join sql query laraveljoin same table laravellaravel join db querywhereraw trong laravellaravel eloquent join 4 tablesjoin two models in laravel with or orwhere laravelhow to join data from two tables in laravel eloquentlaravel orwhere joinmultiple table connect laravelhow to multiple query in laraveljoining in laravellaravel eloquent join with where conditiontwo table join in orm laraveljoin laravel withlaravel table joinusing select query and join in laravelleftjoin laravel joinlaravel query builder join two other tablesjoin 3 tables sql laraveljoin tabels laravellaravel inner join tables from another databaselaravel select with join and wherejoin two table laravelhow to add condition to join query builder in laravellaravel 8 join multiples tableslaravel eloquent join examplelaravel query builder left join multiple conditionseloquent join two querieslaravel joining two querieslaravel eloquent join 2 tables with wherejoining two table in laravelmultiple table join in laravel with conditionsjoining two tables in laraveljoin tow table in laravellaravel join tables modellaravel api join 2 table inner join 3 table laravelleft join multiple where laravellaravel inner join tables from other databaselaravel eloquent join 3 tableshow to show the data by join two tables in laravellaravel join select from multiple tableslaravel mysql join 4 tableslaravel jointurlaravel query 3ewith join conditionadd more than on condition in join in laravellaravel join multiple tableeloquent left join multiple conditionsphp laravel mysql join tablejoin table in laravelquery builder laravel to join two tableseloquent joins laravel arrayelequent joinlaravel join multiple table with wherlaravel join 2 tablemultiple conditions join laraveleloquent model join with tablehow to use left join two table in laravellaravel eloquent 3ewith join conditionlaravel two joinsadd more than one conditions in join in laravelhow to join 4 tables using eloquent in laraveljoin 3 table in laraveldb table left join table laravelwith eloquent joinjoin three table in laravel using eloquentlaravel join 2 tablesmodel return data with join tables in lara veljoin query laravel with conditionjoin multiple tables in laravel mysqleloquent join 3 tableshow to full join tables in laravellaravel join two tablesfilter data laravel join query multiple tableow to join multiple tables using query builder in laraveljoin table in laravel eloquent showingjoin multiple condition in laraveljoin 4 tables in laravel eloquentlaravel join two tables with conditionsjoin three tables laravel eloquentlaravel join onwheredoes join query eloquent laraveljoin two table from different connection laravellaravel join using two conditionsquery buider join 3 table laravelhow to combine two joins in laravelhow to join tables together in laravellaravel use join with eloquentlaravel join three tablescan we join two tables from different databases database in laravellaravel join tables relationshiplaravel join two tables with join other tableslaravel join select multiple lineslaravel join tables in modeltwo results left join laravel eloquentlaravel db join selectjoin two tables in laravel controllerlaravel using where and whererawlaravel join arraylaravel whereraw betweenlaravel join model with tablelaravel query builder joinslaravel join query but only one record from join tablelaravel left join there tablesjoin multiple table tables in laravel queary bilderlaravel query join selectselect query from table in laravel with jointwo table join in laravelmultiple join laravel eloquentjoin multiple tables in laravel 7 mysqljoining many tables eloquent modelhow to join two tables in laravel 8 with eloquent relationshipslaravel join 2 tablaslaravel equivalent join with another databaselaravel eloquent joineloquent with multiple tables in laraveljoining 4 tables in laravel controllerjoin 1 1 laravellaravel eloquent two joins in condition from the same tablejoin parameters in laravelblade joinleft join with multiple conditions laraveldatabase join table use for one to one in laraveljoin with where clause in laravellaravel left join two tablesmultiple join on same table laraveleloquent join tablehow to make inner join for 2 tables in laravel eloquentlaravel eloquent to join table based on two conditionseloquent left join multiple conditions with integerlaravel eloquent two joins in condition from the same joined tablelaravel join wherehow to concatenate two query result laravel in onejoin multiple tables in laravellaravel innerjoin two tableslaravel eloquent join onlaravel query join 3 tableslaravel orm query joinhow to use join in search query of laravellaravel join two tables aslaravel join tables with multiple conditionslaravel left join 273table join laravelhow to join two tables together in laravel eloquent laravel multiple joinshow to joint two table in laraveljoin two table using laraveltable join database for get data in qloquent laravelquery builder in laravel 8 joinlaravel raw query joinjoin more eloquent laravel more than onelaravel join query eloquentjoin with multiple condition in laraveland in join eloquenteloquent query builder inner join andjoinlaravel eloquent join with where clausemultiple join using eloquent laravel problemslaravel orm jointwo table join query in laravellaravel query with model join 28 29join two table using model in laravelwhereraw query in laravelmultiple on join laravellaravel join tabljoin with condition laravel dbtwo condition left join laravlejoin query in laravel eloquenteloquent joinwherelarave joinjoin with 2 conditions laravellaravel inner join modellaravel join whererawhow to join two tables in laravel searchlaravel join two table select one rowlaravel join tables and get results in both tables commonjoin another db laravellaravel inner join modelslaravel left join multiple on conditionsmultiple joins with select in laravelas in join laravel on multiple columnseloquent join querylaravel multiple joins relationsjoin tables in laravel 8join in data get in two queries laraveldb join query in laraveljoin tables laravel eloquentjoin two table and get data in laravel eloquenttype of join laravelselect and inner join laravellaravel db table join multiple wherejoin same table in laravelmulti where in join laraveljoin query eloquent laravelhavingraw in laravellaravel join 2 tables joionlaravel joins eloquenttwo join calling in laravel elequenthow to join two tables in laravel 8 step by step join two table in laravel eloquentlaravel join 3 tablehow to join 3 tables using laravel eloquenthow to combine 2 column data in where clause laraveljoin with laravelcan we use with in join query in laravellaravel inner join using modelsget 2 tables by join laravelhow to join table with relationship in laravellaravel join tables eloquenteloquent join selecteloquent join w table laravel 8merge two eloquent results with joinself join in laravel query builderjoin 2 tables in laravel 8how to use join in laravel eloquent with where condition3 table join in laravel queryfull join query in laravellaravel inner join two tableslaravel join table different databaseinner join 3 tables laraveljoins in database in laravelleft join 2 table laravellaravel or joinhow to join query join with model in laravel 8laravel join andhow to join tables and access data in laravel eloquent using with methodjoin existing query laravellaravel eloquent join querylaravel join two tables by andlaravel eloquent join subquerylaravel join table select whereeloquent join query laravellaravel query builder join with usingjoin two tables can insert data in laravelhow to join multiple tables in laravelquery inner join laravelhow to use two join in laravel eloquenteloquent join query laravel db 3a 3atablewhere in laravel query after join tablejoin with multiple conditions eloquenthow to join two tables in laravel eloquentpass two table name in db join in laravellaravel join with two conditionsjoin two table in laravel using eloquentlaravel join two tables with modeljoin multiple columns laravellaravel left join two tables whereinner join with search in laravel 8inner join in laravel nested query buildermultitple tables join in laravelhow to join two tables together in laravel eloquentlaravel inner join ormhow to create relationship between join tables in laravel using database tables without modelsjoin parameter laraveldb query builder inner join laravelhow can i join two tables in laravel using query builderjoin 3 tables sql laravel 8eloquent joins cross joinjoin table other connection laraveljoin table with model laraveljoin with select in eloquentlaravel multiple queryes with one connectionquery builder to eloquent join converterhow to join two tables in laravel db querylaravel eloquent join modelslaravel join select multiple rows from joinedlaravel eloquent merge tableslaravel db 3a 3atable few tables joinselect on join items in query laravellaravel join withjoin tabel laravel laravel eloquent left join multiple conditionsdb table join 3 tables laraveljoin two table and get data in laravel eloquent withjoin two tables info in laravel to view itlaravel join two tables whereinhow to join tables in leoquent using withmultiple table to join in laravellaravel eloquent join tableright join laravel query builderjoining two tables in laravel using eloquenthow to use where on join tables in laravel eloquent how to joing two laravel eloquentlaravel eloquent builder joinlaravel multiple table join table return value eloquent join with conditionlaravel 8 join two table eloquent6 tables join laravel 8join with 2 field laraveljoin table in laravel with conditionsselect join laravel query builderlaravel join closure add 2 tablesmultiple condition in laravel join onlaravel join with table from other dbhow to join two table in laravel modellaravel join and row selectlaravel eloquent where multiple conditoonlaravel eloquent join 4 tables where clauselaravel two table join query by modellaravel query join with 3 different columnshow to join 3 tables in laravel 8how to join tables in select on laravel using eloquenteloquent join on two column multiple join condition in laravellaravel how to join many table with one tablejoin tow tables in laravelhow to show index in table list join two table in laravel 7how to join 3 tables in laraveljoin three tables eloquenthow to join multiple tables to get their data laravelwhere on join query builder laravellaravel left join with two conditionslaravel eloquent model join multiple tableslaravel outer joinlaravel eloquent join select with where clauselaravel 2 model elqeunt joincombine two tables laravel controllerjoin table in laravel eloquenthw to join 2 tables in laravel using eloquent builderhow to join 2 or more table in laravellaravel db join querylaravel query builder join and join two table and get data in laravel eloquent without joinjoin query in laravel with on and conditionjoin laravel with other join of other tableeloquent query builder inner join and in joinlaravel select where and joinlaravel joins getting one table dataeloquent join model query with where condition laravelusing join query in two tables in laravel 8collection join laravelmulti join laravellaravel join 2 tables in modelhow to join two table in laraveljoin 4 tables laraveleloquent join with multiple conditionslaravel select 2 tableslaravel api join 2 tables examplelaravel join one to many concatenatejoin quesry details in laravellaravel query inner joinjoin two table in laravelthree table join laravellaravel selectraw whererawlaravel join two tables using laravel whereraw examplemultiple where condition to join laravelhow to join two tables with different name in larave 3bjoin subquery db builder laraveleloquent join 2 tableeloquent laravel join table 3a 3aquery 28 29laravel join multiple conditions with variabkelaravel join 2 tables joion with selectrawlaravel join with multiple join conditionshow to join two tables in laravel 8 and get dataleft join 2 tables laravellaravel join 3 tables and third is subjobjoin with there laraveleloquent combining joins with where statementjoin in query builder laravellaravel join with query builderlaravel join multifull complete example use of join query in laravel 8join 3 tables laraevleloquent join multiple onlaravel join three tables queryelequent join multiple tableslaravel db make multiple inner joinon one tableeloquent joinlarravel joinlaravel use eloquent for joining queryhow to join table of two models in laravellaravel query builder join with multiple conditionslaravel db multiple on in joinlaravel model join 2 tablesjoin three tables in larvellaravel eloquent join 2 tables and compare two tablesmultiple join query in laravellaravel eloquent join with selecteloquent where join table laraveljoin multiple tables in laravel eloquent