CodeSmith Community
Your Code. Your Way. Faster!

WhereClause for two table

Latest post 03-18-2007 9:40 PM by elfederiko. 0 replies.
  • 03-18-2007 9:40 PM

    WhereClause for two table

    Hi People.

    I Have two table one "Contact" and the other is "Category".

    In one page i have a advance search.  When i can search for Name, Last Name, Phone, and Category. I create a querystring and call another page to show the result. For the search by Name, Last Name or phone no problem, but for category i don't know how to do it. I know that i have to search in the table ContactInCategory and get all the ContactID for the select category in the search. Then Search in the contact table and get all the information for those id.

    Please if someone can help me.

    sorry for my bad English.
     

    elfederiko
    • Post Points: 5
Page 1 of 1 (1 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems