AND with left join

[sogescomputer]

In Fabrik->List->join

I do a join like this:

select id from table1 left join table2 on table1.id = table2.parent_id AND table2.published = 1

How to 'AND' clause?

thanks.

 

[cheesegrits]

Nope, can't do that.

Although you could use a pre-filter to simply remove published != 1 from view.

-- hugh

 

[sogescomputer]

Your suggestion is not applicable, because the prefilter applies a 'where', and the result is different from what I want.
thanks