selecting only the fields with the same name from two tables

From: Sanjin <sanjin.m_at_SoftHome.net>
Date: Tue, 14 May 2002 00:27:43 +0200
Message-ID: <abpem3$53cg$1_at_as201.hinet.hr>

Hello,

I am using oracle 8 and I need to move data from old to new database.

How to get (using sql queries) as the query result from i.e. 'table1' and 'table2' only fields that have the same name?

Thanks in advance,

Sanjin Received on Tue May 14 2002 - 00:27:43 CEST

This message: [ Message body ]
Next message: Leader: "Re: How to insert data in a column which datatype is CLOB by an insert statement?"
Previous message: Ban Spam: "Re: Inserting text which contains newlines, using SQL"
Next in thread: T R: "Re: selecting only the fields with the same name from two tables"
Reply: T R: "Re: selecting only the fields with the same name from two tables"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message