-
Ok, I think I got it
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|