Anthony Brown wrote:
I have one database that I would like to split into two..
Well actually my client does.. I don't think we should.
But, is there a way to join data from the seperated databases?
One table authors will be connected to a table called contacts each residing
in different databas
arl
script. However I'm using a generic SQL reporting tool, so my only chance is to use
pure SQL instructions.
- Original Message -
From: Peter Brawley
To: Ernesto Silva ; [EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 1:10 AM
Subject: Re: Joining data
Ernesto,
Ernesto,
Are you looking for this?
SELECT *
FROM transaction
INNER JOIN purchased_product ON
transaction.number=purchased_product.transaction
INNER JOIN payed_amount ON
purchased_product.transaction=payed_amount.transaction
WHERE transaction.number=1;
PB
- Original Message -
From: Er
