List of user accounts in MySQL using the command line?

SQL with both column values exist in another table

Petrov

I have 2 tables Table T1 with 2 columns(i.e. C1 and C2) and Table T2 with 1 column (i.e. C3). I want to get only those records from T1 such that value in C1 and C2 (both together) exist in C3. Is my sql good ? Any alternatives?

Select * 
From T1
Where (T1.[C1]
        IN (Select T2.[C3]
            From T2))
      AND
      (T1.[C2]
        IN (Select T2.[C3]
            From T2))