Mutiple WHERE clauses.... Help

Results 1 to 3 of 3

Thread: Mutiple WHERE clauses.... Help

  1. #1
    Michael V Guest

    Default Mutiple WHERE clauses.... Help

    I guess I should brush up on my SQL! I am trying to select records that is either one or another. Would this be right?<BR><BR>select * from LessonPlans where Grade=1 OR 2<BR>or<BR>select * from LessonPlans where Grade =&#039;Kindergarten&#039; OR &#039;Preschool&#039;<BR><BR>I think it is, but I can&#039;t quite remember. I tried serching for it but nothing came up.<BR>TIA<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default No that is not right

    select * from LessonPlans where Grade in (1,2)<BR><BR>or<BR><BR>select * from LessonPlans where Grade = 1 or grade = 2<BR><BR><BR>

  3. #3
    Michael V Guest

    Default Thanks!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts