Is it possible at all to use conditional joins in views?
ie:
select a.* , b.* from a inner join b ON ( (a.id = b.id) AND
(a.otherfield ?) )
I have a few 15-20 table joins that i'd like to push into views.
i've never wanted to push something with a conditional join into a
view before,
Am Dienstag, 24. April 2007 21:43 schrieb Jonathan Vanasco:
Is it possible at all to use conditional joins in views?
ie:
select a.* , b.* from a inner join b ON ( (a.id = b.id) AND
(a.otherfield ?) )
I have a few 15-20 table joins that i'd like to push into views.
i've never wanted