hi, i want to define a view like this: select * from tablea a left join ( select * from tableb where f_deleted = 0) b on a.id = b.id
but i only can define like this: select * from tablea a left join table b on a.id = b.id when i add a where condition where f_deleted=0 , .. the result is different :( i can't find any info about that in entity engine guide, there is no where condition tag, how i can ? thx!
