I just started using MySQL, so I can't confirm this, but if it is really not
possible, maybe someone could consider implementing something like Oracle's
database links ? It might be a good thing for the beer industry ;-)
Only a suggestion...
Marc
Op Sunday 18 March 2001 01:10 kon c.smart het niet nalaten op te merken:
> Sorry, No Green Beer, No can do that ;-)
>
> Richard Reina wrote:
> > I am try to do a join with tables that are in two different databases.
> >
> > I thing I've got the actual SQL syntax down:
> >
> > my $q = "SELECT i.inv_no, i.inv_date,
> > c.cust_name
> > FROM receivables.invoice i, sales.customer c,
> > WHERE i.paid_date IS NULL";
> >
> > but I am confused on how to prepare and execute it, since my database
> > handle ($dbh) specifies only 1 database.
> >
> > Any help would get me out of the office on St. Pats day and in fron tof
> > a bar maid serving green beer. Please help make my day.
> >
---------------------------------------------------------------------
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
