Compare two columns?

Question

SQL

Is it possible to compare data in two columns?
That is, we have two tables ( tbl1 and tbl2 ), each of them has a name column .
In tbl1 name = vasy, pety, kira, and in tbl2 name = kira

Answer 1

Googled query examples with NOT IN
https://www.sqlite.org/lang_expr.html
The IN and NOT IN operators take an expression on the left and a list of values ​​or a subquery on the right. When the right operand of an IN or NOT IN operator is a subquery, the subquery must have the same number of columns as there are columns in the row value of the left operand. The subquery on the right of an IN or N

Answer 2

Use not in
or join:

select
t1.name
form tbl1 t1
left join tbl2 t2 on t2.name = t1.name
where t2.name is null