Re: Views

Try adding one more condition to the view definition:

AND
PHONE.OWNER = ADDR.OWNER it might help.....

null <null_at_yahoo.como> wrote:

>This is what the view is doing:
>
>What is coming back incorrectly, is the addr.FORMAT as Addr_Format
>information. What is seen in the view is different than what is actually in
>the ADDRESSES table.
>
>CREATE OR REPLACE VIEW V_RPT_CONTACT_ADDRESS_PHONE ( ID,
>POPCODE, OWNER, CONTACT_FORMAT, TITLE,
>CONTACT_TYPE, CONTACT_DESC, NOTES, PHONE_FORMAT,
>EXTENSION, COMMENTS, PHONE_TYPE, ADDR_FORMAT,
>STREET, ADDR_DESC, FLOOR, SUITE,
>CITY, STATE, ZIP ) AS select
>
>contact.ID, -- contacts
>contact.popcode,
>contact.owner, -- varchar2(20)
>contact.FORMAT as Contact_Format,
>contact.TITLE, -- varchar2(50)
>contact.TYPE as Contact_Type, -- varchar2(50)
>contact.DESCRIPTION as Contact_Desc, -- varchar2(50)
>contact.NOTES, -- varchar2(2000)
>phone.FORMAT as Phone_Format , -- varchar2(50)
>phone.EXTENSION , -- varchar2(4)
>phone.COMMENTS , -- varchar2(50)
>phone.TYPE as Phone_Type , -- varchar2(20)
>addr.FORMAT as Addr_Format , -- varchar2(50)
> addr.STREET , -- varchar2(128)
>addr.DECRIPTION as Addr_Desc , -- varchar2(50)
>addr.FLOOR , -- varchar2(50)
>addr.SUITE , -- varchar2(50)
>addr.CITY , -- varchar2(50)
>addr.STATE , -- varchar2(50)
>addr.ZIP -- varchar2(50)
>
>from contacts CONTACT, PHONENUMBERS PHONE, ADDRESSES ADDR
>WHERE PHONE.OWNER = CONTACT.NAME_ID
>AND ADDR.OWNER = CONTACT.NAME_ID
>
>Steve McDaniels wrote:
>
>> Is the data changed or is the ORDER of the data is changed?
>>
>> null <null_at_yahoo.com> wrote in message news:386115C4.1B4AC519_at_yahoo.com...
>> > Running Oracle 8.0.5.2 on Solaris 2.7
>> > There is a view created that accesses data from a particular table.
>> > However, when querying the actual table the data comes back differently
>> > than what results when querying the actual view.
>> > I'm not sure what would cause this, and would appreciate any ideas or
>> > suggestions.
>> >
>> > Thanks in advance.
>> >
>> >

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Dec 22 1999 - 15:29:03 CST