On 7/15/06, Paul S <[EMAIL PROTECTED]> wrote:
This is definitely doable.
one "Set" way that I could think of doing this would be to first compile a temp table with all of the Value/Pairs that your looking to search for and then just JOIN the ID's (in this case it would be the Value and Pair) to
On 7/15/06, Stefan Arentz <[EMAIL PROTECTED]> wrote:
I'm no SQL expert by any means so I'm wondering if something like thisis possible.I have two tables like this:create table Errors ( Id serial not null, CreateDate timestamp not null, primary key (Id)
);create table ErrorValues ( Id serial not
This is definitely doable.
one "Set" way that I could think of doing this would be to first compile a temp table with all of the Value/Pairs that your looking to search for and then just JOIN the ID's (in this case it would be the Value and Pair) to the ErrorValues table. This should give you
I'm no SQL expert by any means so I'm wondering if something like this
is possible.
I have two tables like this:
create table Errors (
Id serial not null,
CreateDate timestamp not null,
primary key (Id)
);
create table ErrorValues (
Id serial not null,
ErrorId int not null,
Name varchar(2
