Home » SQL & PL/SQL » SQL & PL/SQL » status related issue (9.0.4.0)
status related issue [message #327696] Tue, 17 June 2008 05:22 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

We have 2 systems A and B. the data from A will send to B.
System A:
selet a.productno,a.location,b.status
  from items a,records B
  where a.productno=b.productno
o/p:

Productno    location    status
--------------------------------
1234            345        Close
4321            342        Close
9870            443        Open
9675            908        Open
8907            907        Close

System B:
select a.item,a.loc,b.UOM,b.status 
  from items a, stat b
  where a.item=b.item
o/p
Productno    location    status
--------------------------------
1234            345        Open
4321            342        Open
9870            443        Open
9675            908        Open
8907            907        Close


Now the problem is System A will send data to B.
but in 'A' the status of productno 1234 is "closed" but in "B"
it shows the status as "Open". Like this for some items I am getting the problem at "Status" column.
So can any one please help me in query to show the status as same in the both the syaytems.

If u need more information please let me know.
Thank you.

Re: status related issue [message #327699 is a reply to message #327696] Tue, 17 June 2008 05:48 Go to previous messageGo to next message
saikumar_mudigonda
Messages: 23
Registered: June 2008
Location: hyderabad
Junior Member
Is this what you are looking for ?

SQL> select * from items;

 PRODUCTNO   LOCATION STATUS
---------- ---------- ----------
      1234        345 close
      4321        342 close
      9870        443 open
      9675        908 open
      8907        907 close

SQL> select * from stat;

 PRODUCTNO   LOCATION STATUS
---------- ---------- ----------
      1234        345 open
      4321        342 open
      9870        443 open
      9675        908 open
      8907        907 close

SQL> select a.productno,a.location,a.status
  2  from items a ,stat b
  3  where a.productno = b.productno
  4  and a.status = b.status;

 PRODUCTNO   LOCATION STATUS
---------- ---------- ----------
      9870        443 open
      9675        908 open
      8907        907 close
Re: status related issue [message #327701 is a reply to message #327696] Tue, 17 June 2008 05:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
INTERSECT

Regards
Michel
Re: status related issue [message #327702 is a reply to message #327699] Tue, 17 June 2008 05:56 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi ,
The data in the system "A" will send to system "B". means status for any item should be same . But Productno 1234 shows status as "Close" in system "A" .But after sending data to "B" it shows "open" for Productno 1234.
for this I need to write a query if what is status of the productno in ystem "A" should be same as the system "B"
for this I need to write a query.

Thank you.
Re: status related issue [message #327704 is a reply to message #327702] Tue, 17 June 2008 05:59 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do it!
You have all the information to do it.

Regards
Michel
Previous Topic: i need a query
Next Topic: VARRAY
Goto Forum:
  


Current Time: Fri Dec 02 13:58:52 CST 2016

Total time taken to generate the page: 0.09334 seconds