Hi everyone,   See if someone could give me a hand. My scenario is similar to this: Table 1 ID ID2 Whatever rest columns... 1 AA ... 2 FC ... 3 OM ... 1 BB ... 1 MQ ...   Table 2 ID ID2 Whatever rest columns... 1 AA, BB ... 2 FC ... 3 OM ... 4 BB ... 5 MQ ...   You see that I have two identifiers. The first table we could say is a collection of logs, while the second one is the most updated inventory. What I would like to do is perform an 'inner join' so I only get the rows from Table 1 whose ID1 and ID2 exists in Table 2. Resulting in this: ID ID2 Whatever rest columns... 1 AA ... 2 FC ... 3 OM ... 1 BB ...   The row with ID 1 and ID2 MQ will be removed.   Thanks for your help 😄 ... View more

Hi, See, I have been trying to group my result query based on the latest date in order to remove duplicates and get the most recent one. This is an example of what I have: Field1 Field2 Date AAA 111 21 Jan 2021 AAA 111 22 Jan 2021 BBB 332 20 Jan 2021 BBB 552 22 Jan 2021   And what I would want to have: Field1 Field2 Date AAA 111 22 Jan 2021 BBB 332 20 Jan 2021 BBB 552 22 Jan 2021   I would really appreciate the help.   Thanks ... View more