DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: need help!!

  1. #1
    Join Date
    Nov 2000


    I am trying to generate a report from remote database.
    I have 4Q's each Q joines 2 tables.
    Q1(travel_amt) , Q2(payroll_amt), Q3(received_amt),

    I am trying to put these data in one table and then generate
    my report. The problem is that the 4Q's has to be ordered by
    job_no before I can put them in my table (TO MAKE SURE THAT I AM GETTING THE COREECT RECORD).

    to do this, I've tried to create 4 views and then create my table based on these views. I couldn't do this because I wasn't able to create my views using order by( because views & order by is not supported in oracle8.0.5!!!! ).

    any ideas !!!!!!! or maybe work around it.


  2. #2
    Join Date
    Sep 2000
    Can you insert unique job_no only rows into your table from the 8 remote tables. Then use that key to extract the rest of the data and update the rows.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.