Re: [SQL] join if all matches

2005-11-28 Thread Bruno Wolff III
On Tue, Nov 22, 2005 at 10:30:17 +0200, Sim Zacks <[EMAIL PROTECTED]> wrote: > I am trying to figure out an sql statement and I was hoping someone could > help. I'm having brainfreeze right now. > > Table Rules > RuleID > RuleName > > Table RuleAgents > RuleAgentID > RuleID >

[SQL] join if all matches

2005-11-26 Thread Sim Zacks
I am trying to figure out an sql statement and I was hoping someone could help. I'm having brainfreeze right now. Table Rules RuleID RuleName Table RuleAgents RuleAgentID RuleID Agent Table RuleActions RuleActionID RuleID Action I am passing in an array of agents