Speed enhancements - one select, nested select, two consecutive s elects

["Brown, Bryan" <bbrown2@ACSALASKA.COM>]

Good morning everyone!

Thanks to everyone's help, I managed to get my last report off the ground
finally - Thanks!

On a different report, I have an extremely slow report. I was wondering
about performance of SQRs - which is the faster approach....

1.) A select with Joined tables
2.) Nested Select (i.e. select a from b where b = (select c from....)
3.) Two select statements:
   a.) Select a from table1
   b.) Select b from table 2 where c=a.table1

Thanks,
Bryan

------------------------------------------------------------
Bryan E. Brown
bbrown2@acsalaska.com, 907-564-1303
Systems Analyst, ACS (Alaska Communication Systems)
SQRW  V3.0.13.2, CSS Hrizon ver 8, Oracle 7.3.3, NT (server & workstations)