How to get exclude of 2 columns of one table with another table

Community Support
1

If I like to find the record of one table with a column not from a column from another table, I can do the following:

  select from t1 where not col1 in exec col1 from t2

but if I like to exclude with 2 ( or more ) how can I do?

 

2

q)t1:(ab`c;y:0 1 2;z:3 4 5)

q)t2:(ab`d;y:0 1 2;z:6 7 8)

q)select from t1 where not (x;y)in select x,y from t2

x y z

c 2 5

3

Thanks a lot Charles, I should know it before asking