Post reply

update data if row count matches based on column

  • April 12, 2018 at 2:58 pm

    #344373

    i have two table with same number of columns. I want to update two columns from table B to table A. I want to make sure that the number of rows are same and then i do the update. 
    Example below table with 4 column each. Column B and Ba have same kind of values that can be used to count the rows.
    pls help. thanks
    Table A-
    A    B         C     D
    1 2016-06 NULL NULL

    Table B-
    A   Ba        C   D
    2 2016-06 10 10
    3 2016-07 10 10

  • April 12, 2018 at 3:16 pm

    #1986686

    The 2 tables don't have any data in common. That is, none of the ID values match from A to B. They don't have the same number of rows. What you asked makes no sense to me. Would you care to explain what you're trying to do. Post create table scripts, insert statements with your data, what results you're after and what you've tried so far.
    Thanks

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply