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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
