On Fri, Apr 30, 1999 at 11:33:53PM -0400, Michael Longval wrote:
> But how would I do it if I wanted the 1 most recent record from
> 3 or 4 tables, using search criteria in each case, then
> combined into a join.
Huh? Please give an example of what you want. If you're joining
several tables, then you just do it the exact same way as if you're
using one table. If, on the other hand, you have several tables
with the same fields (e.g., all 4 tables have a 'foo' field), and
you want the most recent value of 'foo', then you should change
your database structure so that they're all in one table.
Tim
