Member Avatar for jeyjey88

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 because: n/a
  • 3 Contributors
  • 3 Replies
  • 102 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by jeyjey88
Member Avatar for mwasif

Are you looking for this?

SELECT * FROM test1, test2 WHERE test1.data!=test2.data
Member Avatar for anand01

Try this

SELECT test1.data FROM test1 JOIN test2 ON test1.data!=test2.data
Member Avatar for jeyjey88

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.