If you find these tutorials useful, Please consider making a donation. |
|
|
|
|
|||
LibreOffice Base - Group 15 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 |