We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
With app As ( Select * From tablea a Inner Join tableb b On a.serno = b.serno ) Select * From ( Select col1, col2, serno From app Where newvalue =1 And oldvalue =0 ) aNew Inner Join ( Select col1, col2, serno From app Where newvalue =0 And oldvalue = 1 ) aOld On aNew.serno= aOld.serno Inner Join tablec c On c.Column2 = aNew.serno
Join the community of 500,000 technology professionals and ask your questions.