Using and & or in the same query

• rehook2003

  SSC-Addicted

  Points: 499

  More actions

  November 10, 2005 at 11:26 pm

  #166631

  I'm having trouble getting this to return the correct result.

  It returns any and all rows that match the OR conditions

  SELECT * FROM tableA

  WHERE

  FullName = 1

  OR MailingAddress = 1

  OR Phone = 1

  OR Fax = 1

  OR Email = 1

  AND ListingID = 10

  I understand why it returns the other rows, but I cannot figure out how to only return the desired row.

  Any help would be appreciated

  Thanks in advance

  Rick

   

• [KH]

  SSCommitted

  Points: 1908

  More actions

  November 11, 2005 at 12:09 am

  #603367

  is your conditions :

  - ListingID equal to 10

  - FullName = 1 OR MailingAddress = 1 OR Phone = 1 OR Fax = 1 OR Email = 1

  then the OR should be place in '(' and ')'

  SELECT * FROM tableA

  WHERE ( FullName = 1

  OR MailingAddress = 1

  OR Phone = 1

  OR Fax = 1

  OR Email = 1

  )

  AND ListingID = 10

• rehook2003

  SSC-Addicted

  Points: 499

  More actions

  November 11, 2005 at 1:32 pm

  #603500

  KH,

  Thanks for the answer,

  I'll know for next time as I should be using some more of these down the road

   

  Thanks again

  Rick