Carol,

>> 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......

> 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.

     I think what I'm using can use the first syntax but I'm not for sure.   

     I need to set up some test databases again...  (Pending finishing up
configuring the new drive space I added to my server, & configureing
for use a couple of old hp xw8000 workstations I just picked up...




Jame

--- BBBS/LiI v4.01 Flag