If all the databases are running in the same mysqld then it might be
possible, if you have select permission on all of them and you preface the
table names with the database name. (select * from database.table...) You
will have to use a JOIN clause to get them all into a single statement which
means you will have to make sure that all the fields line up datatype wise.
In short, You may be able to but I'm not sure it's wise.(IMHO) I would
attempt to do it in your native language. (PHP, PERL, Java, etc.)
Cal
http://www.calevans.com
-----Original Message-----
From: Mat Jones - booksellersolutions.com
[mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 11:19 AM
To: [EMAIL PROTECTED]
Subject: newbie help
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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
