Yea
right! Someone in the office of our new parent company had too much time
on his hands...
-----Original Message-----
From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 1:47 PM
To: Multiple recipients of list ORACLE-L
Subject: OT RE: Select won't work for view createYea, I noticed that.Lisa musta gotta raise.(congrats!)-----Original Message-----
From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 1:27 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Select won't work for view createNow that is one fancy signature!-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, Lisa
Sent: Thursday, April 05, 2001 1:03 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Select won't work for view createHi Dan,are you referencing public synonyms in your statement?
Lisa Rutland Koivu
Oracle Database Administrator
[EMAIL PROTECTED]
4850 N. State Rd. 7, #G104Ft. Lauderdale, FL 33319
Phone: 954.484.3191
Fax: 954.484.2933
-----Original Message-----
From: Dasko, Dan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 12:36 PM
To: Multiple recipients of list ORACLE-L
Subject: Select won't work for view createI have a select that works fine. However, it doesn't work fine when I try to create a view of the result set. There is nothing particularly fancy about the query, just a plethora of outer joins from the main table to the secondary tables. I get an error back about one of the tables not existing, but like I said, it works as a select, just not as a create view as ...FWIW Oracle 8.0.6 on DG-UXDan