Are you sure you don't want to come join us?
Are you sure you don't want to come and join us?
I don't really see any difference between these two sentences. I guess in the second one you're asking two distinct questions
Don't you want to come? Once you're here wouldn't you like to join our group?
But conversationally I think they're the same.