BizTalk Utilities CV ,   Jobs ,   Code library
 
Home Page


Add/Edit your code items
Search the code library
Browse for the code library

Uncategorized

Uncategorized

Uncategorized Contents

Re: Filtering unique values
Re: Grouping with totals/subtotals -- nested Muenchian method
Grouping with totals/subtotals -- nested Muenchian method
Generic JScript Function To Load XML Data
WebCube Report - Browser-based Multidimensional Data Reporting
The pow(a, b) function
Re: Missing constant definition
A simple template to display singular and plural counts
swapping two integer values without using temporary
Debugging script
Combinations of k out of n numbers
Permutations of the values of N nodes
What is BEEP (BXXP)?
Family Tree maker
Alternative Ordering - ""Women and Children to the lifeboats first""
Meta-Patterns: Design Patterns Explained
XML Helper functions in Visual Basic
nodeset of child templates using document()
Converting INI files to XML
Table with more than one column
 
 

<< System.XMLWCF, WS, SOAP >>

By Daraesh Mistry
First Posted 03/27/2001
Times viewed 211

Comparing Multiple fields from the subquery

Summary Comparing Multiple fields from the subquery

If you have used subqueries then you would have noticed that records returned by the subquery can contain only one field/expression if introduced by the IN keyword unless introduced by the EXISTS keyword. If a combination of multiple fields in the outer query needs to be compared with a combination of multiple fields in the inner query then a '+' operator is required to combine the multiple fields. N.B : The '+' operator will only work if the fields of the same data type are combined. It gives a error if fields of different data types are combined. The following snippet illustrates the functionality.

Additional information

Further additional information

Rate this article on a scale of 1 to 10 (0 votes, average 0)

Your vote :  

<< System.XMLWCF, WS, SOAP >>



Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown:

 
 

    Email TopXML