Yep...one more sip of coffee. I neglected to take out a literal table name from the bottom piece.=20 Sorry about this. ...i promise not to post anything before 8:30am anymore! :)=20 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Stephens, Chris Sent: Tuesday, October 26, 2004 7:55 AM To: mwf@xxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: Something I'm missing in minus set operation... No...i actually didn't do a straight copy and paste...i have 'where owner=3D3D'OWNER';' Sorry about that.=3D20 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mark W. Farnham Sent: Tuesday, October 26, 2004 7:52 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Something I'm missing in minus set operation... I'm guessing you probably want owners and table_names in there someplace..... -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Stephens, Chris Sent: Tuesday, October 26, 2004 7:46 AM To: oracle-l@xxxxxxxxxxxxx Subject: Something I'm missing in minus set operation... We have a table here used by a web app to determine columns for particular tables. The table is out of sync with the actual columns in the tables. To determine which columns should be removed from the table I wrote the following: Select distinct(trim(col_name)) >From owner.col_dim Minus Select distinct(trim(column_name)) >From sys.all_tab_columns; ...but that is yielding the wrong results. What am I missing? The datatypes are the same. ...i don't even think I should need the trim in there but that too yields wrong results. ? ....it is very early here so I have somewhat of an excuse. Thanks chris=3D3D20 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l