I have a signifigant number of tables that each have a name_date naming scheme. I want to write a function that takes a start and end date as arguments, and optionally a name, and returns a view of all tables joined together by the name of the supplied name, er - if supplied. is there a better way to go about this? one question left unanswered is how do I somehow automagically drop the view once a user is done with it. suggestions and comments welcomed. thanks eric
