Thanks to Adrian Roe, Jon Walthour, and Rodd Holman for their helpful
replies.
The text that Jon provided worked perfectly. Scored big points with my
users.
Thanks for taking the time to help me out,
Cherie Machler
Oracle DBA
Gelco Information Network
Yep, looks good (I'm a SQL7/2000 DBA).
"INNER JOIN" etc.. is not SQL Server specific, It's just ANSI standard.
If you have.
select col1,col2,col3
from table1 inner join table2 on table1.id=table2.id
you can then change this to the following to get it to work on Oracle
select col1,col2,
Cherie,
I may be completely wrong on this, but I seem to remember my Intro to
SQL instructor at Oracle Ed telling the class that a MS SQL inner join
was the same as just a normal join in Oracle.
HTH (List please correct me if I'm wrong)
Rodd
On 03 Aug 2001 09:10:42 -0800, [EMAIL PROTECTED] wrot