Rich, You're certainly right. However I've actually simplified the table structure here in order to not over-complicate matters. I'm pretty certain the schema is good, but if you have the time/willingness to work through the whole thing with me, my AIM is NeonNinjaSan or ICQ 51549640 - I don't want to waste your time if you don't have it though. Cheers.
Also, to answer your question, yes an object with the property "green" might also have the property "yellow" with a different score. Rich Shepard wrote: > > Why have the ID columns? If each Object_name and Property_name is > unique, > they don't need a surrogate/artificial integer primary key. > > I'm not trying to sound pompous, but your schema may be causing your > difficulties in writing quick running queries. > > > Can an object also have the properties of "yellow," "cool," and "dull?" > > If you are concerned with query running times it's often good to look > at > the DDL and see if it's as efficient as can be. > > Rich > > -- > Richard B. Shepard, Ph.D. | Integrity > Credibility > Applied Ecosystem Services, Inc. | Innovation > <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: > 503-667-8863 > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Query---finding-objects-with-given-properties-tp22312313p22313518.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
