• The view is not created from the table,

    The table is created from the view.

    So i created the table then inserted the data from the view.

    I have a script which fires every minutes if there any any new rows.