Three tables to one
From: EMW (someone_at_MikroZoft.com)
Date: 01/10/05
- Next message: Marina: "Re: Three tables to one"
- Previous message: MSz: "IIS 6 in Win XP x64"
- Next in thread: Marina: "Re: Three tables to one"
- Reply: Marina: "Re: Three tables to one"
- Reply: fred.nelson_at_tstc.edu: "Re: Three tables to one"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 10 Jan 2005 21:55:30 +0100
Hi,
I have an Oracle database with different tables of data.
They all have one common field.
I need to combine some fields from three tables.
i.e.
field1 and field2 from table1
field3 and field4 from table2
field5 from table3
Alltogether I want to produce a dataset with one table with the following
schema: common, field1, field2, field3, field4, field5
How can I do this?
Can I do it by excecuting a SQL command to the database or do I combine the
data within the dataset or is there some other way of doing this?
My program is in VB.NET.
rg,
Eric
- Next message: Marina: "Re: Three tables to one"
- Previous message: MSz: "IIS 6 in Win XP x64"
- Next in thread: Marina: "Re: Three tables to one"
- Reply: Marina: "Re: Three tables to one"
- Reply: fred.nelson_at_tstc.edu: "Re: Three tables to one"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
