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
Hi,
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 databases on the same ser
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 Silva
To: [EMAIL PROTECTED]
Sent: Monday, June 09, 2003 8:07 PM
Subject: Joining data
I have three tables, to model a purchasing system:
transaction
number
client
date
purchased_product
transaction
product
price
payed_amount
transaction
date
I have three tables, to model a purchasing system:
transaction
number
client
date
purchased_product
transaction
product
price
payed_amount
transaction
date
amount
This model allows me to have a transaction with multiple products and also
record several payments on the trasacti