Hello,
I'd like to ask you if it is possible to substract one query from the second query. Both queries have the same columns and they are put in the same order, so their composition is identical.
In the 1st query there is a list containg some names that may be also in 2nd query and other names that are only in the 1st query.
My goal is to select only those names that are in the 1st query, and at the same time are not in the 2nd query.
Is it possible to do?
If not with queries, maybe with tables?
Thank you in advance for any help.
I'd like to ask you if it is possible to substract one query from the second query. Both queries have the same columns and they are put in the same order, so their composition is identical.
In the 1st query there is a list containg some names that may be also in 2nd query and other names that are only in the 1st query.
My goal is to select only those names that are in the 1st query, and at the same time are not in the 2nd query.
Is it possible to do?
If not with queries, maybe with tables?
Thank you in advance for any help.