Returns all Places with Place Details and the Persons or Families (couples) and their Facts, including Shared events, using the Place Detail.
 |
| Results from FactsHavingPlaceDetails3 as displayed by SQLiteSpy |
Returns all Places with Place Details and the Persons or Families (couples) and their Facts using the Place Detail. No shared events.
 |
| A comprehensive query by Romer. Screenshot from SQLite Developer. |
This simpler query should run fast on very large databases with all sqlite3 managers.
 |
| A simpler query by ve3meo. Screenshot from SQLite Developer. |