-Ursprüngliche Nachricht-
Von: c.smart <[EMAIL PROTECTED]>
An: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Datum: 18 March, 2001 01:11
Betreff: Re: join from two different databases
>Sorry, No Green Beer, No can do that ;-)
&
Richard,
On Fri, Mar 16, 2001 at 06:05:52PM -0600, 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,
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
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.cust
