I want to execute a single search statement that mimics a SQL select statement that uses a "Join".   For Example,  Template A has 2 fields "DocumentID" and "LastName".  Template B has 2 fields "Town" and "State".  I search Template A by "LastName".  Next, I want to search Template B by any "DocumentID" that was returned from the first search.

The search in SQL syntax would look like this.

Select LastName, CustomerID, Town, State from TemplateA

Left Join TemplateB on TemplateB.DocumentID= TemplateA.DocumentID

Where LastName='Jones'

I tried using LaserFiche Query Language but encountered a problem in what was needed in the selected fields.   It appears that one of the templates must contain all of the fields selected or zero records are returned.  My problem is that I am selecting different fields from different templates.

Thanks,

Bruce