Join example

Hey

I'm having trouble understanding how join works in schematic/content providers. I have two tables and I want to query them joining them by their ids.
Inserting wasn't a problem as I inserted them both separately in both the tables. I saw a few issues referencing @Join and join but couldn't understand them.

Any help would be appreciated.
Thanks