locked
SQL to fetch xml...how to ?? RRS feed

  • Question

  • Hi all,

     

    Could anybody help me on converting this sql query to xml query by attributes:

     

    SELECT   FilteredAccount.accountid, FilteredAccount.name

    FROM     FilteredAccount INNER JOIN

               FilteredContact ON FilteredContact.parentcustomerid = FilteredAccount.accountid

    WHERE   (FilteredContact.intercom_support_managerid = '{F31D9D73-EA8C-DF11-9F21-00215A1F6AE3}')

     

    please note that i have failed to do it with fetch xml builder

     

    any help will be appreciated,

     

    thanks in advance :)

    Monday, October 4, 2010 6:46 PM

Answers

All replies