Posted by Martijn Tonies on 09/28/07 13:43

> What is the correct syntax to do so.

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?

> I have the same fields in the table.
>
> Tables called Books and Titles
>
> Fields are TitleID and Titles
>
> Using SQL 2000
>
> Please assist.

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

[Back to original message]