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

Thread: need help!!

  1. #1
    Join Date
    Nov 2000
    Posts
    198

    Exclamation

    Hi,
    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),
    Q4(voucher_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.

    thanks




  2. #2
    Join Date
    Sep 2000
    Posts
    14
    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