Search results

Hello, I have a situation which I've not encountered before since I'm fairly new to SQL. I have a table that contains every single user within a building. Each user has a supervisor ID # that indicates who they report to. Since I have their ID # I would like to re-query the same table and get...

I got a solution; SELECT T1.UserName, T1.UserDate AS LastDate, T1.UserPosition AS LastPosition FROM Table1 AS T1 INNER JOIN (SELECT T2.UserName, Max(T2.UserDate) AS MaxDate FROM Table1 AS T2 GROUP BY T2.UserName) AS T3 ON (T1.UserName = T3.UserName) AND (T1.UserDate = T3.MaxDate) WHERE...

Anyone have a suggestion? :(

Alright it works, but it doesn't work if I have more data. It starts creating duplicates because it can't group them. I should have included this in my original post. For example, an associate's position can change from week to week. For this query, I don't really care about that, but I do want...

Wow, I can't believe I didn't think about that. Thanks a bunch I'll give it a try

Yeah I've been using Max to display current week, no issues there. Just not sure how to approach listing users that are no longer active compared to previous weeks

Hi, I have a table that gets updated on a weekly basis with the names of active users. I'm trying to make a query that tells me which users are missing from the current week compared to the entire table/all previous weeks. I only want the user to show up once, and it has to be the newest data...

Hi everyone, I've ran into an issue I've not had to deal with before. I have two tables, both are similar, but one table has a few more columns than the other one. I'd like to have a single query for both tables that displays combined results including all the columns from both tables. I know...