Logo Home    Page list

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.
www.000webhost.com