[ic] Cascaded query against multiple tables

Interchange User interchange-users@icdevgroup.org
Wed Jul 2 13:05:00 EDT 2003

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  

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  

	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  



More information about the interchange-users mailing list