Mutiple tables connection

Author Name Status Posted Time Haseena Sabir Mohammed 2/12/2007 12:26:16 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 Mutiple tables connection Andrez Sudol 2/12/2007 12:29:26 AM don't believe that there is. Besides merging the data into one table and adding a field to dif ferentiate which old table they came from, the solution could be rather cumbersome, if the data needs to be sorted together. To do that, you would load all the results into an array (or some thing similar) and sort it using the method of your choice. Post Comments Re: Use Foriegn key Nujin Jacob 8/17/2007 10:45:29 PM Use Foriegn key for relation 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?