topic Approach to looping through and comparing data in App Development

Approach to looping through and comparing data

ant2 — Wed, 01 May 2024 13:38:36 GMT

Hello.

Lets say I have Table A:

Table A

- Id

- EnterDate

- StaffNum

- Site

I need to find:

Query 1. All rows from Table A where Site = 'North'

Query 2. For each row returned in Query 1, I then need to find any rows in Table A where the StaffNum is equal, Site = 'South' and EnterDate is greater than the EnterDate returned in Query 1.

Lost on this one, any advice on starter code would be greatly appreciated.

Thanks.

Re: Approach to looping through and comparing data

rwunderlich — Wed, 01 May 2024 14:32:01 GMT

"For each row returned in Query 1,"

Should the Query 2 then match first on id field?

-Rob

Re: Approach to looping through and comparing data

ant2 — Wed, 01 May 2024 14:52:33 GMT

Hi Rob

Thanks for the reply.

Query 2 should first match StaffNum, e.g. if Query 1 returned a row where StaffNum was 12345, then Query 2 then needs to find all rows in Table A where StaffNum is 12345, but also where Site = 'South' and EnterDate greater than the EnterDate returned in Query 1.

Cheers.