WOW, This code as i see someone else complain, way to complicated to try and reformat. But that aside, few issues, 1=1 on an inner join, well actually in any...