Comparing two tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JJ297 - 28 Sep 2007 14:36 GMT

Could someone assist me...I'm trying to compare data in two tables
called Books and Titles

They both have the title field and I'm using SQL 2000 but have access
to SQL 2005. Tried the except method in 2005 but getting invalid
syntax on except.

Thanks

Reply to this Message

David R. Longnecker - 28 Sep 2007 16:06 GMT

Are you trying to compare these in DataTables in .NET or with TSQL code?
Also, what are you trying to compare? If information exists in one table
and not the other? If the two tables are identical? etc?

-dl

--
David R. Longnecker
http://blog.tiredstudent.com

> Could someone assist me...I'm trying to compare data in two tables
> called Books and Titles
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

JJ297 - 28 Sep 2007 17:15 GMT

On Sep 28, 11:06 am, David R. Longnecker
<dlongnec...@community.nospam> wrote:

> Are you trying to compare these in DataTables in .NET or with TSQL code?
> Also, what are you trying to compare? If information exists in one table
[quoted text clipped - 15 lines]
>
> - Show quoted text -

I was trying to compare the values in two tables in SQL but just
realized I don't have to do so. Will get the user to do this since
they know the data.

Reply to this Message

Patrice - 28 Sep 2007 17:14 GMT

The first step would be to post the query and the error message.

Instead of using the title to link both tables, it would be likely better to
use an identifier field (for example if you correct a mistake in the title
or if two books are using the same title you won't be able anymore to find
out the authors).

--
Patrice

> Could someone assist me...I'm trying to compare data in two tables
> called Books and Titles
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Rate this thread:

Comparing two tables

Free Magazines