My current employer has MANY graphically created NESTED JOIN queries. They drive me crazy with their complexities and normally have duplications. Is there a a reference some place on-line or a textbook that will serve as a good help in re-constructing them into a more straight-forward simpler format.

I would just like to have a reference showing the typical way to simplify the complex query designer results.

I found...

We set up one client in our web Win2000 Server, IIS 5 with a SSL cert. It is http://www.proorthoped ic.com. A customer just called to say that a security
analysis of his web site advises that his site works fine when http://www.kiplinggema ppraisers.com. However when https://www.kiplinggema ppraisers.com is entered the user is directed to the proorthopedic site instead. What do we need to do to stop the redirecting to the secure site? If...