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

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

2005-09-06 Thread Bruno Wolff III
On Fri, Sep 02, 2005 at 20:40:24 +0100, DownLoad X <[EMAIL PROTECTED]> wrote: > 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 a

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

2005-09-05 Thread Thomas F. O'Connell
On Sep 2, 2005, at 2:40 PM, DownLoad X wrote: 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 integ

[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

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

2005-09-02 Thread Oz
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 object