Re: Searching Multiple Tables

2001-02-24 Thread Fred van Engen
On Fri, Feb 23, 2001 at 03:05:19PM -0500, Sander, Ryan wrote: > I doing a newspaper site. My database has a different table for each > category (local, sports, etc). All of the columns are the same for each > table (Headline, byline, body, etc). Is there any way to search all of the > tables at

Searching Multiple Tables

2001-02-24 Thread Sander, Ryan
I doing a newspaper site. My database has a different table for each category (local, sports, etc). All of the columns are the same for each table (Headline, byline, body, etc). Is there any way to search all of the tables at once (since they all have the same columns)? To further illustrate.