[ic] Cascaded query against multiple tables

[Interchange User]

Greetings,
	
IC 4.9.8 nightly, MySQL 4.1

I need to run a query against table1.  Based on what I find there, I  
need to take the results, and search with them against table2 and  
table3.

Table1 has a list of authors, with an index into articles they have  
written. I need to search the authors list for an author's name (via a  
text input), then, once I have that information, I need to hit table2  
and pull out all articles they have written, and table3, which contains  
supplemental information on the articles (which I can do with a join).   
I know I can do a join for the second query, but I don't know how to  
access the results from the second part of the query as search criteria  
using ITL.  Does anyone have any examples of this?

In MySQL, I would first

select articleid from nc_authorarticle where authordisplay like  
"%some_author's_name_here%";

	This would give me back a list of integers which I would then use in  
the following:

select distinct title, pubdate, from nc_redarticle, nc_authorarticle  
where nc_authorarticle.articleid = nc_redarticle.uniqueID and  
nc_redarticle.uniqueid=__whatever_articleids_were_returned_from_previous 
_search;


Thanks,

Peter