I was making it harder than it really was, I think I figured it out. I used an inner join.

SELECT tblContent.ForeignKey AS contentFK, tblContent.Title, tblLinks.LinkURL, tblLinks.LinkParentMenuNone, tblLinks.MenuItemLinked, tblLinks.SortOrder, tblLinks.ForeignKey, tblLinks.Published FROM tblContent INNER JOIN tblLinks ON tblContent.ForeignKey = tblLinks.ForeignKey WHERE (tblLinks.LinkParentMenuNone = 'parent') AND (tblLinks.Published = 1)ORDER BY tblLinks.MenuItemLinked, tblLinks.SortOrder