Skip to Content
0
May 27, 2018 at 08:39 AM

How to Return Values from Multiple Tables by Using Case ?

74 Views

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