vendredi 5 juin 2015

How to use select statement in an If condition

I have a variable which contains value '1'

current code:

if var1 in (1, 2, 3, 4) then ...

Required format (I don't want to hard code the comparison values):

if var1 in (select col1 from table1) then ...

Select col1 from table1; 

1  
2  
3  
4 

Aucun commentaire:

Enregistrer un commentaire