locked
How to convert inner join to QueryExpression? RRS feed

  • Question

  • sql:

     

    select * from lead
    inner join listmember on listmember.entityid=lead.leadid
    where
    listmember.listid='1E565422-A7AE-E011-958A-000C29295BC9'
    and lead.emailaddress1='test999@gmail.com'

     

    how to covert above sql into QueryExpression?

    Wednesday, July 20, 2011 9:53 AM

Answers

  • Hi nixjojo,

    You need to used linked entity. I suggest you use a tool - fetch XML tool (stunnware) which you can download for free. HERE

    Help you generate the code easily.

    thanks

     


    regards,
    Toong Yang
    http://eastoceantechnical.blogspot.com/
    • Marked as answer by nixjojo Wednesday, July 20, 2011 12:21 PM
    Wednesday, July 20, 2011 10:02 AM

All replies