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.
For some reason, nothing from JobMaster is coming through (it's all NULL)
SELECT dbo.Invoice.Company, dbo.Invoice.Vendor, dbo.Invoice.JobNo, dbo.JobMaster.JobName FROM dbo.Invoice LEFT OUTER JOIN dbo.JobMaster ON dbo.JobMaster.Company = dbo.Invoice.Company AND dbo.JobMaster.JobNo = dbo.Invoice.JobNo
Join the community of 500,000 technology professionals and ask your questions.