I got it, this was an old copy of the original database i tested on but it didnt have that column. I created a new db copy and am busy...

This seems like the thing I'm looking for.

Both are however returning "Invalid column name 'PIMS_IMPORTED",

I am busy investigating

Thanks

Thanks Han Shi,

I will have a look at this method!

I just want a separate job that will automatically execute the results of the select statement instead of running it manually one by one

Hi Steve,

Thanks for the reply, after checking my initial post I realized I explained a bit wrong.

This view I am talking about has 2 tables (diagram pane). From these 2...