Continuing on the topic of SQLite joins, we will be talking about the different types of joins possible within SQLite.

When you open the SQLite Wizard, under Query Builder, add in your columns of interest. From here, choose the files of interest and create a join between boxes by dragging a connection between the entries in the two columns.

Upon viewing the preview, you may notice that you are only shown a few items. If something doesn’t look right, or you want to see more information, you can click on the join itself.

Here, you can select between multiple different join types (inner join, left outer join, right outer join, and full inner join). Choosing different join types allows you to see more or fewer results, as desired.

Inner Joins meet all the requirements of the boxes you have selected while Left Joins are broader and display more results.

Share this post