1 Reply Latest reply on Feb 1, 2007 5:11 AM by Dan Bracuk

    where clause problem

    RyanG24 Level 1
      Hi i have a query which shows records, i have added ***AND MT.Model_ID = '#session.ModelNo#' *** to my query.

      but this ony shows models that match the session, what i need is, if a group of ranges has say 5 models but it includes the model in the session, then i want to show all models

      ie this would be the output displayed

      "range1" "model2" "model3" "model4"

      and my session = model3

      at the min because of the where clause all i get is "range1" "model3"