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