Hello,
I have two tables which contain records (rows) of unique values. What I need to find is which of the records from Table 1 are in Table 2 but with a specific different value for one of its columns.
Ex. Lets say record 1 from table 1 is:
I want to see if this record exists in table 2 with each of the column values the same, except the year value being a value of only greater by 1. I.e. I want to verify this record is present in table 2 but in a 2011 year.
How can I see if record 1 from table 1 (along with a bunch of other records from table 1) exist in table 2 but in the record's following year?
Thanks for the direction.
Greemo
I have two tables which contain records (rows) of unique values. What I need to find is which of the records from Table 1 are in Table 2 but with a specific different value for one of its columns.
Ex. Lets say record 1 from table 1 is:
| ID# | Name | Year |
| 1234 | PROJ1 | 2010 |
I want to see if this record exists in table 2 with each of the column values the same, except the year value being a value of only greater by 1. I.e. I want to verify this record is present in table 2 but in a 2011 year.
How can I see if record 1 from table 1 (along with a bunch of other records from table 1) exist in table 2 but in the record's following year?
Thanks for the direction.
Greemo
