Variables in the Select Statement

[Anon]

Ok, I have a table where one of the fields is ProductType. So for a menu I SELECT DISTINCT ProductType...

But also, I've created the naming scheme so that the ProductType's are also the names of the other tables in the DataBase.

That way I can do:
SELECT ProductClass FROM $ArrayProductType[ProductType]

This, I thought would give my database amazing growth potential. But the SELECT statement doesn't seem to like the $ArrayProductTye[ProductType]

Can I not use variable in the SELECT statement?

Thanks

[Anon]

Nevermind, I was getting ahead of myself because my code extracted the table names from SELECT DISTINCT FIELD but I the one of the table names it extracted was for a table that didn't exist yet. Make sense?

Thanks
-Keith