A query or datatable is required to find the difference between two tables

Question

HI

I have a table between some products and another table with some products. I want to specify only the different products between the two tables.

table prod a --col prodnama
gh1
cd2
at3

table prodb --col prodnamb
at3
cd2

Result gh1

Answer 1

If you need the names only, then check this query:

(
    select prodnama from proda
    except
    select prodnamb from prodb
)
union all
(
    select prodnamb from prodb
    except
    select prodnama from proda
)