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
WebCube Report - Browser-based Multidimensional Data Reporting
Re: Missing constant definition
swapping two integer values without using temporary
Debugging script
What is BEEP (BXXP)?
Meta-Patterns: Design Patterns Explained
XML Helper functions in Visual Basic
nodeset of child templates using document()
Converting INI files to XML
Fullxml 2
Sorting the results and use the Axis
TreeMaker
XMLEditor - WebClipping
WDDX Parser
Templx: x++ IDE Released!
XppEngCOM: COM implementation of x++ interpreter
Backup Outlook mail as XML
 
 

<< System.XMLWCF, WS, SOAP >>

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

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 (1 votes, average 5)

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