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