[SQL] Searching for results with an unknown amount of data

2005-09-05 Thread DownLoad X
Hi, I've got two tables, A and B, the first one containing columns A_ID | info where A_ID is primary, so that this table stores various information about an object, and the second containing columns A_ID | property where property is an integer referring to a particular property that an obj

Re: [SQL] Searching for results with an unknown amount of data

2005-09-07 Thread DownLoad X
> Now, I want to find all objects that have at most properties 1,2,3, say (so > something with (1,2) is okay, as is (1,2,3)). I can't see a way to do this > -- can anyone help? It sounds like you are trying to find all objects that do not have any properties outside of a specific list. One w