mercredi 23 décembre 2015

Issue in Laravel 5.1 Inner Join Query

Below is my Query in Laravel 5.1

\App\Models\Project\Bids\ProjectBid_Model
::selectRaw('B.*')
->join('tblproject P','B.projectid','=','P.projectid')
->where('P.WhoCreatedTheProject',14)
->first()

and below is the equivalant query

select B.* from `tblprojectbid` 
inner join `tblproject P` on `B`.`projectid` = `P`.`projectid` 
where `P`.`WhoCreatedTheProject` = 14 limit 1

What's the problem ?

Please check the line 1 in Query: select B.* from tblprojectbid.

What's the question ?

How can I change

select B.* from tblprojectbid

to

select B.* from tblprojectbid B



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire