Vaibhav Goel
asked on
Can someone plz fix this..getting an error
SELECT
new1.* , new2.*
FROM tables_new new1
CROSS APPLY
(( SELECT MAX(finaltranId) FROM tables_new3 new2 WHERE new1.ckey = new2.ckey )
new1.* , new2.*
FROM tables_new new1
CROSS APPLY
(( SELECT MAX(finaltranId) FROM tables_new3 new2 WHERE new1.ckey = new2.ckey )
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER