SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Could explain to me how join can EXCLUDE
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

JohnCash1
Starting Member

39 Posts

Posted - 10/11/2012 :  22:33:52  Show Profile  Reply with Quote
Could someone explain to me how using joing can exclude
Some information from the same table in Microsoft SQL sever??

For example, if you have a table with one column as A and B.
In this table you also have id key and dates?

So you put all the As into a temp table and you want to exclude the same Id
With Bs that have a date that is greater than any dates in your temp table for the same Id key.

Notes to considered:
You could have many Id keys, many different dates for As.

My Questions would be how do you exclude it if the Bs date is after As date of all the same ids in the temp?

Because As could have so many different dates, how does SQL know to compare the largest date from A to the dates in B?

With just a statement without specify which dates in A?
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000