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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Lobke

  1. Lobke

    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
  2. Lobke

    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...

Part and Inventory Search

Back
Top