I have a moderately complex join statement and wanted to see if the hive mind could find a better way to optimize it.<BR><BR>This is for work so I'm having to obfuscate things a little bit. The ...