Convert to sub query in linq RRS feed

  • Question

  •  Dim dt1 = From a In db.ggn_branches Where a.com_code = CLng(Session("ComCode")) And _
                                   a.branch_code = From b In db.ggn_users Where b.com_code = CLng(Session("ComCode")) And _
                                                    b.user_mobile1 = CLng(Session("UserName")) Select b.branch_code Select a


    Amrendra Choudhary

    • Moved by Steve Fan Friday, October 5, 2018 6:39 AM relocate
    Thursday, October 4, 2018 7:13 AM

All replies

  • Hi Amrendra,

    Welcome to the Visio General Questions and Answers for IT Professionals forum. This forum is for general questions, comments and discussions for IT Professionals on Visio. Since your question is more related to VB.NET, I'll move it to the following dedicated forum:

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    Steve Fan

    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Friday, October 5, 2018 6:38 AM
  • Hi,

    You only provided a piece of code.

    What is your question?

    Best Regards,


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Monday, October 8, 2018 8:16 AM