Datatypes in join columns  How joins are processed

Chapter 4: Joins: Retrieving Data from Several Tables

Joins and text and image columns

You cannot use joins for columns containing text or image values. You can, however, compare the lengths of text columns from two tables with a where clause. For example:

where datalength(textab_1.textcol) >
datalength(textab_2.textcol)




Copyright © 2005. Sybase Inc. All rights reserved. How joins are processed

View this book as PDF