How to do Join

  • sql join

    Hello, I am looking for output where

    EG_RequestID = 175998968 and Reissue from paymentID = 333333 from above both temp table.

    I will get multiple reissue payment ID,

    Can you please help me to write query ?

  • But, from what I can see, the Payment_ID column matches to a value 67280309 for Reissued_from_payment_id. How do you related it to 33333 when the payment_id for that is 22222? I think you need to explain some more what it is that you expect to get from the data you have provided. Based just on the information in front of us, I don't see a solution that will be consistent from query to query.

    Are you trying to find the previous reissued_from_payment_id in the ##second table? If so, can we guarantee the ordering of that column will always be what it is in the example (and yes, before anyone tells me, assuming I put an ORDER BY statement in, of course)? If that's what you're looking for, maybe there's a solution, but you need to explain in more detail.

    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Thank you.  Yes, I used created date order by and it works using function last_value.



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

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