he stored procedure thing and only a little better 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
on 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 don't think that will work because Context_ID is not found in
'target
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
Steve,
> INSERT INTO master_context_list (Context_ID, Target_ID)
>SELECT Context_ID = @ContextID,
the IDs are put 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:
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 co
