Comparing two tables

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.

Re: Comparing two tables

> 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

Re: Comparing two tables

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" wrote in message
news:1190986090.401483.184000@19g2000hsx.googlegroups.com...
> 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.
>

Re: Comparing two tables

On Sep 28, 10:57 am, "Jack Vamvas" wrote:
> 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" wrote in message
>
> news:1190986090.401483.184000@19g2000hsx.googlegroups.com...
>
>
>
> > 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.- Hide quoted text -
>
> - 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.