Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
SELECT MyTable.ID, MyNames.Name FROM MyTable RIGHT OUTER JOIN MyNames ON MyTable.ID = MyNames.ID
But this results in zero records.
WHERE (MyNames.Name IN ('', NULL))
Join the community of 500,000 technology professionals and ask your questions.