> 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 orde
 > > 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
 > couple of old hp xw8000 workstations I just picked up...

Yeah, the logic is the same but the usage differs a bit.  What I see from
reading about, is we can generally figure out one another and ajust although
nested selects can get a little hairy.

Ivan, post some of what you use here so we can get the general flavor?
           xxcarol
--- SBBSecho 2.11-Win32