Igor, Thanks for the help! However, I'm running into an error with the sub-queries returning more than 1 result. I suppose it has to do with the fact that the property "hot" may have more than 1 entry (one for each object). Thanks!
Igor Tandetnik wrote: > > select * from objects where > object_id in (select object_id from properties where > property_name='green' and score > 3) and > object_id in (select object_id from properties where property_name='hot' > and score < 2) and > object_id in (select object_id from properties where > property_name='bright' and score > 0); > > -- View this message in context: http://www.nabble.com/Query---finding-objects-with-given-properties-tp22312313p22313457.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
