<p>Hi Vijay </p> <p>could u please clarify your business rule . going by ur 2nd rule how do u desire row 2 as posted in output like this for product code 11092535 record is existing in @t table and as well its residing in @clnt table also which by rule sh...

Hi Vijay

could u please clarify your business rule . going by ur 2nd rule how do u desire row 2 as posted in output like this for product code 11092535 record is existing in @t table and as well its residing in @clnt table also which by rule...