Posted - 10/11/2012 : 22:33:52
| 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?