Home » SQL & PL/SQL » SQL & PL/SQL » Problem in joining 2 queries (Oracle 10g,Toad 9.1)
Problem in joining 2 queries [message #335133] Mon, 21 July 2008 02:51 Go to next message
yogeshyl
Messages: 50
Registered: October 2007
Location: Silvassa
Member
Kindly refer the attached queries namely
1)REORDER
2)PENDING WORKORDER

I want to calculate the work order requirement on basis of
Stock, Pending sales order, re-order level and already entered workorders. Now i want to add the first column of 2nd query in the report of 1st query. For that i tried the below statements

AND ITEM_CODE = LCS_ITEM_CODE (+)
AND ITEM_CODE = SOI_ITEM_CODE (+)
AND ITEM_CODE = PWH_ITEM_CODE (+)

LCS_ITEM_CODE is Stock table item_code,
SOI_ITEM_CODE is Sales order item_code,
PWH_ITEM_CODE is Production work order item_code,

When the above statments used while combining the 2 queries does display the result, but the details comes only for the ietm_codes whose work orders are present.

Kindly guide me how can i get the desired output.
  • Attachment: QUERY.txt
    (Size: 6.44KB, Downloaded 136 times)
Re: Problem in joining 2 queries [message #335163 is a reply to message #335133] Mon, 21 July 2008 05:09 Go to previous message
ramanajv1968
Messages: 168
Registered: December 2005
Location: HYDERABAD
Senior Member
It's not possible for every one to download the attachments.
so ,please post them.
Previous Topic: Reading values from a delimited line
Next Topic: How to select oracle sequence from different schema
Goto Forum:
  


Current Time: Fri Dec 09 07:51:36 CST 2016

Total time taken to generate the page: 0.23064 seconds