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
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
related to fields.
Original Message:
-
From: Steen Rabol [EMAIL PROTECTED]
Date: Thu, 31 Jan 2002 21:24:43 +0100
To: [EMAIL PROTECTED]
Subject: Is this possible in one SQL statement
Is this possible in a single select statement ?
table A id (Unique), a_field1,a_field2,a_field3
table
with the value of 3
-Original Message-
From: Steen Rabol [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 2:25 PM
To: [EMAIL PROTECTED]
Subject: Is this possible in one SQL statement
Is this possible in a single select statement ?
table A id (Unique), a_field1,a_field2,a_field3
Is this possible in a single select statement ?
table A id (Unique), a_field1,a_field2,a_field3
table B id(NOT unique), b_field1
Id in table B is a ref to id in table A
Now i would like to select all the id's from table A which have records i
table B where b_field1 is 1 and b_field2 is