Hi folks, Thanks for all, I found it. I use this query. (((( SELECT tbl_product1.part_number, tbl_product1.product_name FROM tbl_product1 UNION ALL SELECT tbl_product2.part_number, tbl_product2.product_name FROM tbl_product2) UNION ALL SELECT tbl_product3.part_number, tbl_product3.product_name FROM tbl_product3) UNION ALL SELECT tbl_product4.part_number, tbl_product4.product_name FROM tbl_product4) UNION ALL SELECT tbl_product5.part_number, tbl_product5.product_name FROM tbl_product5) UNION ALL SELECT tbl_product6.part_number, tbl_product6.product_name FROM tbl_product6; > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx > -- >>Richard Sitompul<< Software Engineer PT. Orbis Indonesia http://www.orbisindonesia.com http://richardsstp.3wsi.net