Is it possible to have "parameters" in views? Such as:
create view v_t1t2 as
select t1.*, t2.*
from t1
left join t2 on t1.id=t2.t1id and t2.other_id = $param
order by t2.name;
John
---------------------------------
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day