-Ursprngliche 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 Reina wrote:
I am try
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 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
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
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