User Profile

Collapse

Profile Sidebar

Collapse
Deven251975
Deven251975
Last Activity: Oct 23 '07, 04:51 AM
Joined: May 18 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Deven251975
    started a topic Need help on Joins..
    in DB2

    Need help on Joins..

    Hi,

    I have two tables as below:
    Table T1.
    CustName
    Data_src
    Timestamp
    Amt

    Table T2.
    Custname
    DataSrc
    timestamp
    adj_amt.

    Now I have to find
    1.distinct custNames from T1
    2.get the timestamp field for the rows found at step1.
    3.get the adj_amt from T2 to each timestamp found at step2.
    4. Display T1,T2 values using...
    See more | Go to post
    • Deven251975
      started a topic Compare two idetical tables and update the table
      in DB2

      Compare two idetical tables and update the table

      Hi,

      I have two identical tables TableA, TableB.
      I have the recent data in TableA because its updated and inserted with new records. Now my Question is I have to compare TableB with TableA and update TableB with TableA's data.

      sugestion and code samples are appriciated.

      thanks.
      See more | Go to post
      No activity results to display
      Show More
      Working...