I am using SQL queries to make multiple lists of values. My table name is SSQW having columns as below;
SSQW_ID, SCHOOL_SESSION, SEMESTER, QUARTER, WEEK_NAME
when I make 1st list of values for QUARTER it works fine, here I am cascading semester value on the page.
but when I make a list of values for the WEEK and cascade quarter, it is not giving me the correct values.
My SQL queries are as under:
Select quarter, semester from SSQW where semester=:P50_semester ( this one is fine)
select week_name, a quarter from SSQW where quarter=:P50_quarter ( this one is not working)
Please if anyone can tell me. what mistake i am making? below is the pic of the table
