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
