0

Hello !!

I need help fot the following situation:

I have 2 tables: test1 and test2:
each one have the same columns name: data
test1:
column data

values (black, white)

test2:
column data
values(white,black,orange, yellow)

what sql sentence i can use to show only the values (orange, yellow) the difference between the 2 tables?

Edited by jeyjey88: n/a

3
Contributors
3
Replies
4
Views
5 Years
Discussion Span
Last Post by jeyjey88
0

Thanks to everyone for replying to my questions!

All seems to work fine.

but particulary i have tried this one:

SELECT DISTINCT test1.data
FROM test1.data
WHERE (test1.data) NOT IN
(SELECT test2.data FROM test2)

it´s a bit more flexible.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.