Search code examples
sqlinner-joinwhere-clause

When was “Checked” added and who added it - SQL

I'm beginning to study SQL queries and attempting to understand some more difficult ones. I have these 2 tables:

User

ID_user
Name

Tracking

ID_Track
Old_Value
New_Value
Date_Entered
ID_user

The data entry interface looks like this:

User                        Column       Date            Old Value            New Value
David (assistant)           Status       02/2022         Pending              Processing
David (assistant)           address      02/2022         Miami                New York City
David (assistant)           Type         02/2022         House                Apartment
David(assistant)            Size         02/2022         Small                Big
Peter(QA)                   Size         06/2022          -                   Medium 
Peter(QA)                   Status       06/2022          -                   Checked

I'm trying to figure out how to join User and Tracking tables in order to know when the word “Checked” was added and who added it.

Solution

  • know when the word Checked was added and who added it

    You can filter the tracking table for the keyword, and then bring the user name with a join on the user table:

    select t.*, u.name
from tracking t
inner join user u on u.id_user = t.id_user
where t.new_value = 'Checked'

    You can add more conditions in the where clause if you need more filtering criteria.