What type of join you are doing? It would probably also depend on the attribute(s) you are joining on and their values.