Comparing two tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JJ297 - 28 Sep 2007 14:28 GMT

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.

Reply to this Message

Martijn Tonies - 28 Sep 2007 14:43 GMT

> 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.
>
[quoted text clipped - 5 lines]
>
> Please assist.

Please be specific.

Signature

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

Reply to this Message

Jack Vamvas - 28 Sep 2007 15:57 GMT

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

Signature

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

> What is the correct syntax to do so.
>
[quoted text clipped - 9 lines]
>
> Thanks.

Reply to this Message

JJ297 - 28 Sep 2007 17:13 GMT

> Are you trying to find if there are any differences . ?
> Could you post the Table definition.
[quoted text clipped - 20 lines]
>
> - Show quoted text -

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.

Reply to this Message