Results 1 to 8 of 8

Thread: how to write a sql with two or more conditions

  1. #1

    Thread Starter
    New Member
    Join Date
    Feb 2012
    Posts
    10

    how to write a sql with two or more conditions

    how to use select * from table where codition1 condition2 condition3
    all conditions related to textbox or combobox value = < > parameters
    please help me.

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: how to write a sql with two or more conditions

    To use multiple conditions in a Where clause, put the keywords AND or OR between them (which one(s) depends on how you want it to work).

  3. #3

    Thread Starter
    New Member
    Join Date
    Feb 2012
    Posts
    10

    Re: how to write a sql with two or more conditions

    i am very new to programming, please provide exect code, table name = tblsales, billno between billnofromtextbox and billnototextbox

  4. #4

    Thread Starter
    New Member
    Join Date
    Feb 2012
    Posts
    10

    Re: how to write a sql with two or more conditions

    other issue with dates same table datefromtextbox datetotextbox

  5. #5

    Thread Starter
    New Member
    Join Date
    Feb 2012
    Posts
    10

    Re: how to write a sql with two or more conditions

    please reply soon

  6. #6
    Frenzied Member
    Join Date
    Jan 2006
    Posts
    1,875

    Re: how to write a sql with two or more conditions

    Go thougth This tutorial and let us know if you have any problem
    __________________
    Rate the posts that helped you

  7. #7

    Thread Starter
    New Member
    Join Date
    Feb 2012
    Posts
    10

    Re: how to write a sql with two or more conditions

    cannot get enough. please provide exact code how to write sql with expressions. please

  8. #8
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: how to write a sql with two or more conditions

    You aren't likely to get much help that way.

    Very few people are willing to give up their own time working for a complete stranger for free. Most of us know that only leads to more of the same, so will only help you if you put in at least some effort yourself.

    You have already been given a link to a brief tutorial which contains examples and explanations, so you should at least try to get it working for your situation - and then if you get stuck, show us what you have done and ask us for help with the specific issue(s) you are facing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width