What am I doing wrong in this sequence. I keep getting an error when I execute
ELSE IF EXISTS (Select c.product_nbr from product_CHECKOUT c WHERE c.product_nbr = @product_nbr) AND
IF EXISTS (Select u.UserID from u_USERS u WHERE u.UserID = @CURRENT_USER AND u.Rule = 1 AND u.ACTIVEFLAG = 1)
Can I express ELSE IF EXISTS AND IF EXISTS ? Can I use the AND here before I give instructions to do something if they both return true?