I have two schemas named as "t3" and "r1". Both have the columns "Permission". Through sql query; I want to Get the list of all permissions from "t3" and excludes the permission from "r1". I am not really into sql that's why it is confusing me a lot.
select *
from t3
where t3.Permission not in (select Permission from r1)
In general, it looks like you need something like that. Although the question is not entirely clear. This is not the most productive option, if there is a lot of data, you can rewrite it in join and it will be more correct.