I have 4-6 Single value entries in my select options say s_test. And Im using this in select statement, I want to catch the s_test entries where it doesn't find entries in the SELECT Statement. How do i achieve this? I tried searching the forum but didnt get any help.
I'm putting it as
select * from ztable where zfield in s_test.
s_test has like 5-6 entries and if the 4th entry is not there in the table I need to catch that. I dont want to loop around s_test and catch it instead is ther any other easy way.