I want if Status column = 1

Check If there are rows in another table return 'Check' and If no rows return 'In DB'

```
SELECT ID, UserName,
CASE [Status]
    WHEN 1 THEN
        if ((Select Count(*) From Logs_TB Where Logs_TB.UserName = Users_TB.UserName) > 0)
            'Check'
        Else
            'In DB'
    WHEN 2 THEN 'Revision'
    WHEN 3 THEN 'Sent'
END AS StatusName
FROM Users_TB CROSS JOIN Logs_TB

```

---

Edit 1:

I have Two Tables

in First Table.
I want to get the following result for Column [Status]

```
if FirstTable.ColumnStatus = 1
   if SecondTable.ColumnA = FirstTable.ColumnB Has Rows
        'Check'
   else
        'In DB'
else if FirstTable.ColumnStatus = 2
   'Revision'
else if FirstTable.ColumnStatus = 3
   'Sent'

```

---

Edit 2

[![enter image description here](https://i.stack.imgur.com/k7KcL.png)](https://i.stack.imgur.com/k7KcL.png)

This is an example

I want Select All Rows From Employment Table

and I want to parse column Status to Column As "StatusName"

if Status = 1 It has two values 

First value Check if QualificationID and SpecializationID Has Rows
in Table 'Vacancies' return 'Check'

and if no rows in Table 'Vacancies' return 'In DB'

if Status = 2 'Revision'

if Status = 3 'Sent'