RE: Using a SQL query to drive another SQL query

2001-03-28 Thread Hayes, David
Subject: Using a SQL query to drive another SQL query I'm running into a bit of a problem making my code work; any suggestions? I'm trying to get data from one SQL routine, and then feed that data into another. Here is the first one: SELECT ID, NAME FROMMySource WHERE NAME

Using a SQL query to drive another SQL query

2001-03-28 Thread Allan . Davis
I'm running into a bit of a problem making my code work; any suggestions? I'm trying to get data from one SQL routine, and then feed that data into another. Here is the first one: SELECT ID, NAME FROMMySource WHERE NAME LIKE '#FORM.junk1#%' I'm then loading the ID values into an array,