Thanks for the answers guys! I wouldn't have thought of that. I just knew someone had encountered this before. Thanks again!
>You can use the UNION operator to simulate a LEFT OUTER JOIN. It would look something like this:
~~~~~~~~~~
Denise
~~~~~~~~~~