Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
linking tables with null value
That doesn't work because both tables have the null in the 3rd column. The fields contain an address: street, number, subnumber the subnumber is for apartments only so it's null most of the time. I need to link the null of table1 with the null in table2 or change the null to 0- Lobke
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
linking tables with null value
I need to link 2 tables based on 3 fields But the 3rd field can contain null values, the problem is that when I link them I don't get results for the rows with null values a, b, c -> a, b, c = works fine a, b, null -> a, b, null = no results is there a way to solve this? Or a way to change the...- Lobke
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 2 Data Access
