[dba-users] SQL question

[Andrew Brown]

This is a simple, ignorant question that arises from fooling with the new  
database. Just to get a feel of what it can do, I'm trying to get it to  
sort out my regular backup CDs and decide which can safely be thrown away  
because everythig on them is duplicated somewhere else.

So, assuming I have two tables, each consisting just of one column, disk  
names, how do I combine them into one column without duplicates in a new  
table?

And what is the mySQL syntax for saying, "I want all the entries in  
Table1.column2 that do not apear in table2.column2"? I guess it has  
something to do with joins, but I can't work it out at all from the mySQL  
documentation. The HSQLDB documentation is of course much worse.

--
Andrew Brown
Tel:    +44 (0)1799-516812
Mobile: +44 (0)7968-945618
What I do: www.darwinwars.com
What I'm up to: www.thewormbook.com/helmintholog/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]