On Sun, 2004-01-11 at 12:22, Daniel Crookston wrote: > The problem I ran into is that I needed a way to get a list of all > procedures for which the chosen doctor does not have a fee schedule set up. > The queries I gave earlier will give this, but I'd like to combine it into > one query if that's possible. If it's not, no biggie, I'll just do the two > of them and live with it.
Well, nuts. You got me really curious but after hacking at it for a few hours tonight I still couldn't come up with anything. Oh sure, I found 2 or 3 ways that involved subqueries. Of course, I don't profess to be the best at outer joins. They scare me a little and I usually get them backwards (left vs right) before I finally end up with the correct query. The queries did work flawlessly under Postgres so you might consider switching if it bugs you enough. Corey ____________________ BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________ List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
