Re: Nested If problem

[Peter Brawley]

if p_overdueOnly = false THEN
  if p_countryID = "DE" THEN
    SELECT 1;
  elseif p_countryID = "BE" THEN
    SELECT 3;
  end if;                -- NEEDS TERMINATING SEMICOLON
elseif p_overdueOnly = true THEN
  SELECT 2;
END if;