From: | Wes James <comptekki(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | how to do this query |
Date: | 2010-01-09 04:26:11 |
Message-ID: | 533df7fa1001082026h53b5d897x2fc1fa2a6f7ff6df@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Barwick | 2010-01-09 09:07:28 | Re: how to do this query |
Previous Message | Seb | 2010-01-08 03:43:57 | Re: Fwd: conditional rule not applied |