What is the correct syntax to do so.

I have the same fields in the table.

Tables called Books and Titles

Fields are TitleID and Titles

Using SQL 2000

Please assist.

Thanks.

To do what exactly?

What do you want to compare? "two tables", what does that mean?
Compare the values in all columns in all rows to all values in all columns
and all rows in the other table?

Or compare the metadata of one table to another?

Or compare a specific row of data in one table to a specific row in
another table?

Please be specific.


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Are you trying to find if there are any differences . ?
Could you post the Table definition.

--

Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL




"JJ297" <nc297 (AT) yahoo (DOT) com> wrote

On Sep 28, 10:57 am, "Jack Vamvas" <DEL_TO_RE... (AT) del (DOT) com> wrote:
I was trying to compare the values in both tables. Realized I don't
have to do that now will create a process so users can do this
themselves! Thanks anyway.