RE: Is this possible in one SQL statement

2002-01-31 Thread Rick Emery
Steen - Original Message - From: "Rick Emery" <[EMAIL PROTECTED]> To: "'Steen Rabol'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 31, 2002 9:35 PM Subject: RE: Is this possible in one SQL statement > Please restate the foll

Re: Is this possible in one SQL statement

2002-01-31 Thread Steen Rabol
quot;Rick Emery" <[EMAIL PROTECTED]> To: "'Steen Rabol'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 31, 2002 9:35 PM Subject: RE: Is this possible in one SQL statement > Please restate the following more completely. I think some ty

RE: Is this possible in one SQL statement

2002-01-31 Thread [EMAIL PROTECTED]
Hard to understand your example: b_field2 is not part of your table b table structure; your example table b rows are missing either their ID field or the non-existent b_field2 and the explanation as to why table A rows A1 and A3 would qualify is not clear when the values 1 and 3 are not relate

RE: Is this possible in one SQL statement

2002-01-31 Thread Rick Emery
Please restate the following more completely. I think some typos got in there. If not, then we need more detail of what you really want. the condition is then value 1 and 3 and the record I want is A1 and A3 due to the fact that a recorc exists in table B with a value of on and one record with