PShannon Posted August 17, 2020 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! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now