>      Note that FTN::Database is hosted at Sourceforge [1] and is also availa
 > at CPAN [2], where there are other FTN related perl modules.
 > 
 >      The SQL side of what I'm doing is not particularly complex (see also [3
 >  I'm basically learning both more about Perl & more about SQL as I go
 > along......


Hehehe I know that one!  I still find explicit joins a bit mystifying at
times.  It's probably more obvious in other SQL DB's but Oracle does the
implicit inner join so well, it can be missed pretty easy.

Today I did a really fast simple one for a co-worker who was access
challanged tot he dbo's.

SELECT * FROM ALL_PERS_GRP A, ALL_CSE_COMPL B where a.emp_id=b.emp_id order
by compl_dt

Ohter DBO's may require something more like 

SELECT * right inner join ALL_PERS_GRP on ALL_CSE_COMPL where (SELECT
ALL_PERS_GRP.EMP_ID=ALL_CSE_COMPL.EMP_ID) order by compl_dt

(or close to that with so many variations of DB engines).

Oh I simplified.  there was also an AND to narrow to a specific course.
         xxcarol
--- SBBSecho 2.11-Win32