Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Enter maximum value on the basis of 2 independent tables. RE: Enter maximum value on the basis of 2 independent tables.

  • February 10, 2018 at 11:03 am

    #1979350

    anujkumar.mca - Saturday, February 10, 2018 8:01 AM

    @Phil \ @george - OrderNo and OrderHeadrNo are two different columns of different tables. Value of both columns must be different that's why identity at a column will not help.

    How is an order linked between the tables, if these numbers are different?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.