SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Combine Multiple Tables

503231Jul 7 2006 — edited Jul 10 2006

How to create fast Query to combine multiple tables to access fast result

Hi I want some solution can any one help me ASAP.

I am using 5 tables and i want to capture a data from all the tables for ex:

Table : Lpo
Table : Sop
Table : Productionadvice
Table : WorkOrder
Table : Mrn
Table : Ptn
Table : inv

I am using Lpono as a reference from Lpo to Inv. In this process there are
chances where i had not made a entry in Mrn or Ptn. but i want to scan all these
tables and capture the data related to Lpono.

Can anyone suggest me the best method how to make a good relation between all these tables
and the entire running process can be seen on Screen.

Regds/Sanjay Pathak

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 7 2006

Added on Jul 7 2006

8 comments

753 views