Please copy the whole SQL again from my previous post, I have edited it in several places. sickid was changed to minsickid in the JOIN "ON" clause and also in the WHERE clause.

If you still have problems, wait a minute till I create the tables here and some sample data, so that I can test it. Writing SQL out of thin air (like I did) is often a source of stupid errors. Sorry for that...