If you take a look here: http://www.hyperion-data.net/dbstuff.html you'll see what's going on. The actual process that all of this is happening underneath is this:
I'm putting together a medical billing website with php/mysql. It handles multiple doctors. It also handles multiple procedures - throat culture, vaccination, etc. Because each doctor charges a different amount for each procedure, I've got a fee schedule database that holds the doctor's id and the procedure's id, plus a dollar amount. I need a way to set up fee schedules for the doctors. The way I'm doing it now is that the user gets a list of all the doctors, chooses one, and then gets a list of all procedures, chooses one, and (on the same page that they choose the procedure) puts in a dollar amount. 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. I've also considered that there may be a better way to design the process of putting together a fee schedule, but since I've got something that's working, I'm reluctant to go back and redo it. Dan > No. Those two queries cannot be combined. Please explain what you're > trying to do and why you think you need them merged and perhaps we can > figure out a solution for you. > > Corey ____________________ BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________ List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
