Ah.. okay.. I'm not the one who designed the database, and the one who did is already implementing that structure. So.. I'm already getting two records per job because the status history has two entries (open and working; a third would bring up three.) This will currently expand to four records if I have two developers on a job.
I can't copy/paste the query, here (dev system is isolated from internet), and it's too much to manually re-type the whole thing, so I can't really give an example of what I currently have. But I currently have 8 left outer joins going. I wanted to try to get this all in one query so I'm not making ten connections to the database. But if this is more complex, perhaps that would be a better idea?
Thank you for your input, I appreciate it.
If anyone knows of a website that can offer ColdFusion help that isn't controlled by neurotic, pedantic jerks* (stackoverflow.com), please PM me with a link.
* The neurotic, pedantic jerks are not the owners; just the people who are in control of the "popularity contest".