SQL -- SELECT Recursive

[Parker Shannon]

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 . . .