Why do I receive an SMS notification from Join and another one from my SMS app?

By default, Join sends a notification for each SMS message or call you receive. It will also sync your SMS app’s notifications separately if you enable it in the Join Android App’s settings -> Notifications -> Notification Apps.

If you want to only receive the native Join notification disable your SMS app’s notification syncing in the aforementioned setting.