What I want to do is list variables in a table by a value contained in another table. For example, the table inventory contains variables for harddrive1,harddrive2,cdrom1,cdrom2,dvd1,dvd2. The value of harddrive1 is from a table named harddrive. In the table harddrive their is a value subcompid. Subcompid is the value from a table subcomp that lists the type of subcomponents. Harddrive, for example, is subcompid=2 or storage.
What I want to do is create a select statement that lists all of the variables from inventory that have a specific subcompid.
I'm not sure if this is doable. Any thoughts?
