Redesign all join statement.