sql inner in appian

Question

Hi, 
 "I have three lists and I need to obtain the values present in all three lists? How can I do this without having to perform an inner join on the database?" 
 ex. list1: {"IT","UK,"DZ", "USA"} 
 list2: {"DZ", "USA"} 
 list3: {"IT","UK,"DZ"} 
 and I need to obtain {"DZ"} 
 
 thanksss

Harshit Bumb (Appyzie) · Answer

Abhishek Karumuru · Answer

hi cugino95 instead of doing that in database it will be easy to do it in appian side using intersection() this function will help you click on the link for more details of that function

sql inner in appian

Top Replies