Dear Experts,
I need to return Values from Multiple Tables by Using Case. How it is possible.
Following is my Query Part.
((Case When dbo.VPM2.InvType = 18 then (Select dbo.OPCH.DocEntry) When dbo.VPM2.InvType = 19 then (Select dbo.ODPO.DocEntry) When dbo.VPM2.InvType = 30 then (Select dbo.ORPC.DocEntry) When dbo.VPM2.InvType = 204 then (Select dbo.OJDT.TransId) End)) As'PayDocEntryNumber',
(((Case When dbo.VPM2.InvType = 18 then (Select dbo.OPCH.DocNum) When dbo.VPM2.InvType = 19 then (Select dbo.ODPO.DocNum) When dbo.VPM2.InvType = 30 then (Select dbo.ORPC.DocNum) When dbo.VPM2.InvType = 204 then (Select dbo.OJDT.TransId) End)))As'PayDocNumber',
In this query I return only first part of the Case Query.
Thanks in Advance
Abdul Rasheed.P