I'm trying to combine 2 queries into 1. I'm just learning sub queries but haven't hit on the right solution to make this query give me the results I need.
Basically, I have 2 tables (modified smaller schema below) where I have folder id and names in one table and folder ids and content ids in the other. I need to be able to run a query where I can get the folder name and content id from 2 different tables using the folder ID. This is to be used for building dynamic web links in a menu.
Thanks in advance for the help!
mnu_id (int) - PK