Comparing two tables

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
 
D

David R. Longnecker

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
 
P

Patrice

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).
 
J

JJ297

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 -

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top