Comparing two tables

  • Thread starter Thread starter JJ297
  • Start date Start date
J

JJ297

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
 
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
 
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).
 
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. Longneckerhttp://blog.tiredstudent.com






- Show quoted text -
Click to expand...

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.
 
Back
Top