I have two tables:
students stu_name schols_selected
scholarships schol_name short_name
schols_selected is made up of scholarships the students have selected,
the field content will look like schol1:schol2:schol3
I need a select that does something like this
select schol_name, short_name, stu_name, schols_selected
from scholarships, students
where short_name is in schols_selected
I have tried:
where short_name like '%' || schols_selected || '%'
but i'm not sure how to include a field result in between like operators.
how do I get a list of scholarships based one which student selected
it where the selected result is a string of colon seperated options?
thx,
-wj