SELECT nova_rebate_plan.rebate_advise
FROM   nova_rebate_plan,
       nova_product
WHERE  nova_rebate_plan.rebate_plan_id = nova_product.rebate_plan_id
       AND nova_product.product = nova_profile.product
       AND nova_profile.leg_id = '';