here’s a good link that I’ve used to help explain to people what joins are and the different types. BAQ is just SQl with a fancy GUI. You can change the type in the bottom right corner just above you criteria tables.
Edit: This was the one I used before. Both are fine, but this one has pictures, which I think help.