Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JohnCash1
Starting Member
39 Posts |
 Posted - 2012-10-11 : 22:33:52
|
| Could someone explain to me how using joing can excludeSome 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? |
|
|
|
|
|
Could explain to me how join can EXCLUDE