If you find these tutorials useful, Please consider making a donation.


LibreOffice Base - Group 15

SQL Join

Video 40 - SQL Join Part 1

We see how to create a query to join the department and group tables to the employee table in both design view and SQL view.

Video 41 - SQL Join Part 2

The difference between an inner and Left (or Right) outer join and how to do them in LibreOffice Base.

Video 42 - SQL SubQuery

How to find all the foreign key records that do not have a primary key using a subquery (a query inside a query). Subquerys can produce the same result set as a Join as well the opposite of a join result set