topic Remove Rows From Table Based on Another Table in App Development

Remove Rows From Table Based on Another Table

kfir1987 — Tue, 11 Dec 2018 08:54:02 GMT

Hi,

I have two table:

1. [Machine Data] - There are 3 columns:

SN, Job#, Time

2. [Job info] - there are 3 columns:

SN, Job#, Completion status.

I have found few job#, SN (The key is both of the fields) on [Job Info] that not appear on [Machine Data] and I want to filter them out from [Job Info]. What is the best practice for this operation? By flag? Minus operation?

Thanks for the help

Re: Remove Rows From Table Based on Another Table

Mark_Little — Tue, 11 Dec 2018 09:09:22 GMT

Hi,

I am sorry i am not following the question, could please supply a little more information and if you could show an example of the issue i.e. what you are seeing and what you like to see.

Mark

Re: Remove Rows From Table Based on Another Table

kfir1987 — Tue, 11 Dec 2018 10:06:19 GMT

Hi,

I will give an example and I hope the question will be more clear:

The table contains the below data:

I want to remove all the rows on [Machine Data] that not appear on [Job info] (The key is SN and Job#).

On the above example, I expect that on [Machine Data] the row with the SN - 4 and Job# - 97 will be deleted.

Why did I expect that? because the SN and Job # do not exist on Job Info.

Thanks