SELECT ADDRESS.RECORD_TYPE, ADDRESS.CEV_NO, ADDRESS.ADDR_TYPE, ADDRESS.ID, ADDRESS.NAME FROM ADDRESS LEFT JOIN LOCAL_ADDRESS ON (ADDRESS.ID = LOCAL_ADDRESS.ID) AND (ADDRESS.ADDR_TYPE = LOCAL_ADDRESS.ADDR_TYPE) AND (ADDRESS.RECORD_TYPE = LOCAL_ADDRESS.RECORD_TYPE) AND (ADDRESS.[CEV_NO] = LOCAL_ADDRESS.[CEV_NO]) WHERE (((LOCAL_ADDRESS.CEV_NO) Is Null));
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.