Select COLUMN_NAME, count(column_name), table_name
FROM DBA_TABLES
group by column_name
having count(column_name) > 1
"Halbert09" <junk01_at_optonline.net> wrote in message
news:338ccebe.0203090848.5e82ee14_at_posting.google.com...
> What SQL+ query would show me those tables that contain columns whose
> names match the column-names of columns in other tables of the same
> schema, and list the tables and matching column-names? Thanks for
> your help.
>
> Harold
Received on Sat Mar 09 2002 - 10:34:12 CST
