Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
monoranjang
Starting Member
1 Post |
 Posted - 2007-05-10 : 07:05:30
|
| I have two tables Encounter & Encounter_History. They have same columns. One column is of type CLOB. My requirement is to retrieve all the distinct records from both the tables with order by a date column. But problem is, UNION does not work in case of CLOB data type.I know it will work if I use UNION ALL, but it returns duplicate records.Please give me suggestion, how to solve this problem.For example: The following query does not work since column1 is a CLOB data typeselect column1 from table1unionselect column1 from table2Thanks |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2007-05-10 : 11:19:13
|
| Isn't CLOB Oracle? |
 |
|
|
|
|
|
UNION for Columns of CLOB data type does not work