Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  recursive query to a level 3 or 4

Author  Topic  Nash Starting Member 1 Post Posted - 2009-09-22 : 10:46:30 Hi The following is my recursive query. But it obviously goes to just one level deep. How can I improve it to go to more levels, say 4 levels. SELECT * FROM BOM M1, BOM M2 WHERE M2.[Child Name] = M1.[Name] Thanks Nash