Steve,
INSERT INTO master_context_list (Context_ID, Target_ID)
SELECT Context_ID = @ContextID, targets_list.Target_ID FROM
targets_list
WHERE Target_ID IN ( SELECT Target_ID FROM #APPLICABLE_TARGET_IDS )
[EMAIL PROTECTED] tells the server to return 1 when the column value
of
into the APPLICABLE_TARGET_IDS temporary table.
steve---
Steven J Orton
Software Engineer
Northrop Grumman Mission Systems
Middletown, RI 02842
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Wed 6/28/2006 4:01 PM
To: Orton, Steve
Cc: mysql@lists.mysql.com
Subject: Re: Tough query to crack
]]
Sent: Wed 6/28/2006 4:01 PM
To: Orton, Steve
Cc: mysql@lists.mysql.com
Subject: Re: Tough query to crack
Steve,
INSERT INTO master_context_list (Context_ID, Target_ID)
SELECT Context_ID = @ContextID, targets_list.Target_ID FROM
targets_list
WHERE Target_ID IN ( SELECT Target_ID FROM
Middletown, RI 02842
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Wed 6/28/2006 4:57 PM
To: Orton, Steve; mysql@lists.mysql.com
Subject: Re: Tough query to crack
/I don't think that will work because Context_ID is not found in
'targets_list' hence the error
at SQL statements as a whole:)
Steven J Orton
Software Engineer
Northrop Grumman Mission Systems
Middletown, RI 02842
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]]
Sent: Wed 6/28/2006 4:57 PM
To: Orton, Steve; mysql@lists.mysql.com
Subject: Re: Tough query to crack
/I