I want to run an SQL like below
Select ID,Rollno,Marks,Name,Section,Teacher from Marks left outer join Student on Marks.StudentID=Student.ID
Now, the Student.ID is having the encrypted value which is not matching with Marks.StudentID (as this is clear value).
I can get the clear value using encrypted value as follow
^StoreValue("EncryptStudentID",Student.ID)=$LB("123"). That 123 is the clear Student.ID which I need to match in SQL query (ON clause).