View: core.salesperson_scrud_view

 CREATE OR REPLACE VIEW core.salesperson_scrud_view
 AS
 SELECT salespersons.salesperson_id,
    salespersons.salesperson_code,
    salespersons.salesperson_name,
    salespersons.address,
    salespersons.contact_number,
    salespersons.commission_rate,
    accounts.account_name
   FROM core.salespersons,
    core.accounts
  WHERE salespersons.account_id = accounts.account_id;