[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

newbie help

To: mysql@xxxxxxxxxxxxxxx
Subject: newbie help
From: "Mat Jones - booksellersolutions.com" <mat@xxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 09 Mar 2001 09:18:39 -0800
List-help: <mailto:mysql-help@lists.mysql.com>
List-id: <mysql.mysql.com>
List-post: <mailto:mysql@lists.mysql.com>
List-subscribe: <mailto:mysql-subscribe@lists.mysql.com>
List-unsubscribe: <mailto:mysql-unsubscribe-treed=ultraviolet.org@lists.mysql.com>
Mailing-list: contact mysql-help@xxxxxxxxxxxxxxx; run by ezmlm (http://www.ezmlm.org)

I have several seperate databases which i would like to search using one sql query. 
All stores have varying field names:

store1.products - author,title,description ...and other fields which i do not need to use
store2.products - artist,title,comments
store3.products - author,title, comments



is there a way I can search all 3 of these, returning the results under the field headers author,title,description sorting them by author. 

If you need any more info, please ask... 

thanks

Mat






booksellersolutions.com

Read what the SF Examiner says about booksellersolutions.com:
http://www.sfexaminer.com/business/default.jsp?story=b.web.0121

2141 Mission St #301
San Francisco, CA 94110
(415) 554-0568

Follow-Ups:
- RE: newbie help
  - From: Cal Evans

Prev by Date: RE: Free Hosting
Next by Date: Big Tables
Previous by thread: Re: Connect Apache
Next by thread: RE: newbie help
Index(es):
- Date
- Thread

This mailing list archive is a service of Copilot Consulting.