[PHP-DB] Re: check two tables at same time? From: Hugh Bothwell (hugh_bothwell <email protected>)
Date: 06/28/02

"Noah Spitzer-Williams" <noahsw <email protected>> wrote in message
news:20020624231958.16545.qmail <email protected>
> hey guys,
>
> im trying to figure out a query that i can return rows from more than
> one table at a time. for example, i have two identical tables in structure

If your tables are 'identical in structure', why have more than one?

ie, instead of

Table A
  ID
  1
  2

Table B
  ID
  3
  4

try

Table Merged
  ID PreTable
  1 A
  2 A
  3 B
  4 B

... this makes it considerably easier to
search with a single query. 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php