In what table is the user_id column?
Have you tried your raw sql in your database client?
On Thursday, April 11, 2013 11:56:34 AM UTC-4, Niphlod wrote:
>
> can you move that *AND user_id = 3* in the where condition ?
>
> On Thursday, April 11, 2013 5:19:15 PM UTC+2, Fabiano Faver wrote:
>>
>>
>
can you move that *AND user_id = 3* in the where condition ?
On Thursday, April 11, 2013 5:19:15 PM UTC+2, Fabiano Faver wrote:
>
>
> niphlod I'm having a problem with left with AND.
>
> this is the sql I want to work:
> SELECT *
> FROM permissao_grupo
> LEFT JOIN auth_membership ON auth_membersh
niphlod I'm having a problem with left with AND.
this is the sql I want to work:
SELECT *
FROM permissao_grupo
LEFT JOIN auth_membership ON auth_membership.id_permissao_grupo =
permissao_grupo.id
AND user_id =3
WHERE permissao_grupo.id_grupo =5
this is what i tried until now:
db((db.permissao_g
the whole point of left= is to trigger a LEFT OUTER JOIN that by design
reports ALL the elements of the left table and only the elements that
matches of the right table
If you don't want this functionality then left= is not good for your usecase
On Thursday, April 11, 2013 4:23:12 PM UTC+2,
4 matches
Mail list logo
