I've inherited a database where the creator seems to not like using NULLs. There are text fields that cannot be NULLs and instead are set to blank. I need to join on these fields. I need to join between two tables where there are records that have blank for a value. I do not want the records that are returned where they are blank. A normal JOIN will match on there unwanted blank data values. How can I do JOIN to get around this?