> -----Original Message----- > From: Wesley Baker [mailto:[EMAIL PROTECTED]
> What I want is to know how to build a SELECT statement which will > return all components of mynewpc and navigate down the > bill-of-materials > and also return all the components for the case, the powersupply and > even the parts on the powersupply. This situation calls for recursion. I don't think you can do it with just SQL. Maybe there's a way to do it that I'm not seeing, though. Faced with the same situation, with Access as the front end, I ended up writing a program in Visual Basic for Applications to do it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
