Facts Having Place Details – Query #placedetails #events

FactsHavingPlaceDetails3.sql

Returns all Places with Place Details and the Persons or Families (couples) and their Facts, including Shared events, using the Place Detail.

FactsHavingPlaceDetails3-results.png
Results from FactsHavingPlaceDetails3 as displayed by SQLiteSpy

 


FactsHavingPlaceDetails2.sql

Returns all Places with Place Details and the Persons or Families (couples) and their Facts using the Place Detail. No shared events.

SQLiteDeveloperSQLeditorFactsHavingPlaceDetails2.png
A comprehensive query by Romer. Screenshot from SQLite Developer.

This simpler query should run fast on very large databases with all sqlite3 managers.

FactsHavingPlaceDetails.sql

SQLiteDeveloperSQLeditorFactsHavingPlaceDetails.png
A simpler query by ve3meo. Screenshot from SQLite Developer.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.