【SQL】查找多个表中相同的字段

--查找字段所在
SELECTbb.TABLE_NAME,bb.COLUMN_NAME ,aa.COLUMN_ID,aa.DATA_TYPE,aa.DATA_LENGTH ,bb.COMMENTS
FROMuser_tab_cols aa
JOIN user_col_comments bb ONaa.TABLE_NAME = bb.TABLE_NAMEAND aa.COLUMN_NAME = bb.COLUMN_NAME
JOIN dba_objects cc ONbb.TABLE_NAME = cc.Object_Name
WHERE 
bb.COLUMN_NAME LIKE '%PRODUCTNAME%'
AND DATA_LENGTH<30
AND DATA_TYPE!='UNDEFINED'
AND DATA_TYPE！='CHAR'
ORDER BYcc.created DESC ,bb.TABLE_NAME,aa.COLUMN_ID ;