Mutiple tables connection

Author Name Status Posted Time Haseena Sabir Mohammed 2/12/2007 12:43:56 AM Author is Offline I was wondering..can I connect 2 or more tables that have the exactly same fields (table1 = tit le, subject, date_time / table2 = title, subject, date_time as well) to be used on a search? I mean..is there a way to make the SELECT statement to grab the content from both tables so wh en the search results appear on the screen they'll be based on both title, subject and date_tim e from these 2 tables? How?

Subject Author Status Date multiple tables connection Andrez Sudol 2/12/2007 12:48:23 AM I don't believe that there is. Besides merging the data into one table and adding a field to di fferentiate which old table they came from, the solution could be rather cumbersome, if the dat a needs to be sorted together. To do that, you would load all the results into an array (or som ething similar) and sort it using the method of your choice. Post Comments Re: multiple tables connection Tom Garvey 2/12/2007 12:51:25 AM Actually... If your table structure is Identical and you're using a SQL table look into the UNION function. http://www.w3schools.com/sql/sql_union.asp Post Comments Re: multiple tables connection Haseena Sabir Mohammed 2/12/2007 12:53:39 AM Hehe After so much time I post here again on this topic. Just wanted to let u know that the UNION function worked thx a bunch. Post Comments Re: multiple tables connection Tom Garvey 2/12/2007 12:55:02 AM Happy to help Post Comments

Related Forums Optimizing Images Get a Website Template for Free!!! Get a Website Template for Free!!! Reply to Hesus!!! Do You Sell Your Templates on Ebay?