Nested If problem

[Russel James]

Im having a problem trying to a nested if statement inside a srpoc.

Here is code that works fine.

CREATE DEFINER=`root`@`localhost` PROCEDURE `usp_StatementsForCountry`(
IN p_countryID varchar(7),
IN p_overdueOnly boolean
)
BEGIN


if p_overdueOnly = false THEN
SELECT 1;
elseif p_overdueOnly = true THEN
SELECT 2;
END if;
END


But this is what I am trying to do..

CREATE DEFINER=`root`@`localhost` PROCEDURE `usp_StatementsForCountry`(
IN p_countryID varchar(7),
IN p_overdueOnly boolean
)
BEGIN


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