On Wednesday 04 May 2005 04:09, Richard Sitompul wrote: Hello Richard! > I have six table_product, for example : > table_product_1 > table_product_2 > table_product_3 > table_product_4 > table_product_5 > table_product_6 > > in table_product_1 until table_product_6 have field part_number and > product_name. I want to ask here, how the query to get the part_number and > product_name in one view(product_view). hm. are you searching for something like this, perhaps? create view product_view as select part_number ,product_name from table_product_1 union select part_number ,product_name from table_product_2 union ... > Any body can help me again? Is it this what you where searching for? HAND && HTH Johannes
