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...

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...