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
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