I'm new to postgres and am trying to display rows in a table that are have a
value between 2 fields.
The rows I want to display should be selected by the grademin or grademax
fields. I'd like to display the rows in sections that are labeled Grades
3-5, 6-8, and 9-12.
The problem that I am having is I can't figure out how to write a statement
that will check both fields. And, especially when I have values in the like
this:
grademin 4 grademax 12 that I want to show up in all levels
grademin 5 grademax 12 ""
grademin 6 grademax 9 in 6-9 and 9-12
Below is what I have so far, but it falls flat on it's face when trying to
display rows that don't fall between the specific range.
How can I check grademin and max in the same statement?
$query = "SELECT
lessonwebid,lessontitle,gradelevel,grademin,grademax,reviewedby FROM
lessonplans WHERE grademin >= 3 OR grademin <= 5";
$query = "SELECT
lessonwebid,lessontitle,gradelevel,grademin,grademax,reviewedby FROM
lessonplans WHERE grademin >= 6 OR grademin <= 8";
$query = "SELECT
lessonwebid,lessontitle,gradelevel,grademin,grademax,reviewedby FROM
lessonplans WHERE grademin >= 9 OR grademin <= 12";
Thanks ahead for any suggestions.
--
View this message in context: http://old.nabble.com/Complex-SELECT-Statement-help-needed-tp27691760p27691760.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.