Join Based on XML fields

• Aparna-1

  SSCrazy

  Points: 2339

  More actions

  May 8, 2008 at 11:34 pm

  #380387

  Hi,

  I am new to working with XML in SQL 2005. I have two tables with XML Fields, I need to join these tables based on the XML fields, but I get the following error.

  "The xml data type cannot be compared or sorted"

  TABLE A

  Field1 (XMLdatatype)

  TABLEB

  Field1(XMLdatatype)

  Select * from A

  JOIN B

  on A.Field1 = B.Field1

• Zubeyir

  SSCrazy

  Points: 2559

  More actions

  May 9, 2008 at 12:25 am

  #812821

  You cannot directly join the xml data type. in BOL start with .value of xml type. Namely XPath.

  Zubeyir

• Aparna-1

  SSCrazy

  Points: 2339

  More actions

  May 9, 2008 at 1:23 am

  #812847

  Thank You I will give it a try.