PShannon 0 Posted August 17, 2020 Report Share Posted August 17, 2020 (edited) I have two tables to manage the hierarchical structure of a corporation (does BOM as well). tblOrganization id formal_name short_name etc . . . tblStructure parent_id (tblOrganization.id) child_id (tblOrganization.id relationship Done this a ton in SQL Server and Oracle (even MS Access) by using: tblOrganization ---> tblStructure <--- tblOrganization_1 I can find no equivalency in MySQL???? What does the MySQL SQL SELECT look like to retrieve that corporate structure? Thank you . . . Edited August 17, 2020 by PShannon Spelling! Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.