CREATE OR REPLACE VIEW core.salesperson_bonus_setup_scrud_view
AS
SELECT salesperson_bonus_setups.salesperson_bonus_setup_id,
salespersons.salesperson_name,
bonus_slabs.bonus_slab_name
FROM core.salesperson_bonus_setups,
core.salespersons,
core.bonus_slabs
WHERE salesperson_bonus_setups.salesperson_id = salespersons.salesperson_id AND salesperson_bonus_setups.bonus_slab_id = bonus_slabs.bonus_slab_id;