Re: Complex view question

Glenn,

> So is there a way to do query 1  with a view?
> 
> The query is not optimized, I want to get it working first.

Data structure, please.  I can't tell what we're working with here.

Also, a statement of what you want the result of the view to be would behelpful.

Finally, it may not be possible to do exactly what you want with a view, inwhich case you'll need to use a straight
query.

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco