Re: check two tables at same time?
| From: | Hugh Bothwell | Date: | Sat, 29 Jun 2002 02:41:18 +0000 |
| Subject: | Re: check two tables at same time? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20194@lists.php.net to get a copy of this message | ||
"Noah Spitzer-Williams" <noahsw@cyberdude.com> wrote in message
news:20020624231958.16545.qmail@pb1.pair.com...
> 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.