Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Oct 26, 1999

Comparing Columns from Different Tables

Question:
I have a problem comparing columns from different tables. I tried:
 
SELECT tblThumBereinigt.Nummer, dbo_BABEWERTUNG.BANUMMER
FROM dbo_BABEWERTUNG, tblThumBereinigt
WHERE (((dbo_BABEWERTUNG.BANUMMER)<>[tblThumBereinigt].[Nummer]));
but this does not give me what I want. How can I compare different tables with an exclusive condition?

Answer:
Try this:

 
select * from information_schema.columns
That should give you a list of information about the columns in your database.

As a matter of form, though, doing the not-equals comparison here matches every row from the left-hand table to every row of the right-hand table, because each instance of number will NOT EQUAL any other, so you'll wind up with a giant cross-join instead.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date