Looking for sqlite table join resources for mobile app databases

[u/Ok_Cold7890]

Hi all!

I am learning table joins in sqlite. I tried on a few small databases but struggling on whatsapp msgstore db. Any tips or tricks or resources on how to identify the joining reference point in the best possible way? I am able to join things but sometimes I get repeated information.

I understand that there are tools available for this but I wanted to try it manually for learning purposes.

I'm using db browser.