Forum Discussion
Curious44
8 years agoNew Member
Joining tables using calculated column
I am trying to join two tables T1 and T2. T1 has a calculated column which is concatentation of fields Type and Age. T2 comes from excel and had the fields Type and Age concatentation performed ...
- 8 years ago
Blanks and nulls can trip you up. Every single value/row in the table on the 1 side of the 1:Many must be unique. So if you can have blank values in this column and there are more than 1 row with a blank column, you will fail this referential integrity test.
Phil_Seamark
8 years agoMicrosoft Employee
Blanks and nulls can trip you up. Every single value/row in the table on the 1 side of the 1:Many must be unique. So if you can have blank values in this column and there are more than 1 row with a blank column, you will fail this referential integrity test.