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

Thanks Jan and Lowell for the help,

I must have made a minor change to the code before I copied and pasted it, but yes I got a totally different error...