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

TheFrugalComputerGuy.png
TheFrugalComputerLogo.png

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