Welcome Guest, Not a member yet? Register   Sign In
INNER JOIN USING
#2
Smile 

Well to answer my own question  in case some other newbie falls into the same pit
I had to alter the statement  from
$builder->join('vehicles', 'e.idvehicles = vehicles.idvehicles');
to
$builder->join('vehicles', 'idvehicles', 'INNER');

also if your query returns more that one row you need to use wherein instead of  where
($builder->wherein instead of $builder->where)

I had to read the BaseBuilder.php  in order to get the info , the documentation is a bit
vague in this .

Thanks for a great tool though . If you need help with documentation  I would be willing to
help you folks.
Smile
Reply


Messages In This Thread
INNER JOIN USING - by stepgr - 06-27-2020, 09:57 AM
RE: INNER JOIN USING - by stepgr - 06-28-2020, 09:50 AM



Theme © iAndrew 2016 - Forum software by © MyBB