This is clearly the Aaron helps day ;-)
Thanks,
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl
---(end of broadcast)---
TIP 6: explain analyze is
Aaron Bono wrote:
On 7/13/06, *Joost Kraaijeveld* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
I have three tables: customers, salesorders and invoices.
Customers have
salesorders and salesorders have invoices ( child tables have foreign
key columns to their parent).
I have three tables: customers, salesorders and invoices. Customers have
salesorders and salesorders have invoices ( child tables have foreign
key columns to their parent).
I want to get a list of all invoices with their customers. This what I
came up with:
select
invoices.objectid,
On 7/13/06, Joost Kraaijeveld [EMAIL PROTECTED] wrote:
I have three tables: customers, salesorders and invoices. Customers havesalesorders and salesorders have invoices ( child tables have foreignkey columns to their parent).I want to get a list of all invoices with their customers. This what I
Hi Aaron,
On Thu, 2006-07-13 at 22:52 -0500, Aaron Bono wrote:
SELECT
invoices.objectid,
invoices.invoicenumber,
invoices.invoicedate,
salesorders.customer,
customers.customernumber,
customers.lastname
FROM invoices
INNER JOIN salesorders ON (
salesorders.objectid =
I want to select some data out of database A, and insert them
into database B. Is it possible to do in one SQL query?
Thanks
Wei
Wei,
I want to select some data out of database A, and insert them into database
B. Is it possible to do in one SQL query?
No. Use a Perl script.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 2: you
See /contrib/dblink, or use an application that attaches to both
databases, or use COPY somehow.
---
Wei Weng wrote:
I want to select some data out of database A, and insert them into database B. Is it
possible to do in