Ambigous results SELECT/Insert-SELECT Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Ambigous results SELECT/Insert-SELECT

  1. #1
    Join Date
    May 2002

    Unhappy Ambigous results SELECT/Insert-SELECT


    When I execute a SELECT query it returns 580 records.

    When I use the same query in the INSERT statement "INSERT INTO SELECT..." it populates 616 records.

    The table into which it is inserted in empty.

    Materialized views are part of the SELECT query. So we removed he materialized views and created tables instead. The problem seemed to be resolved temporarily. But it popped up again now with the tables itself.

    I am unable to comprehend the actual problem. Have any of you faced similar problems or any pointers to the issue?

    Last edited by nandu; 11-16-2006 at 12:44 AM.
    Never give up !

    Nanda Kumar - Vellore

  2. #2
    Join Date
    Nov 2006
    Please do explain plan for both and post the result here. It can give an idea about what happens. The queries would be useful as well


  3. Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts

    Click Here to Expand Forum to Full Width