Results 1 to 4 of 4

Thread: [RESOLVED] Simple SQL select query

  1. #1

    Thread Starter
    Frenzied Member met0555's Avatar
    Join Date
    Jul 2006
    Posts
    1,385

    Resolved [RESOLVED] Simple SQL select query

    Hi,

    I was trying to do a simple SQL select query, but i'm getting no result, but i know the result exist. I will be happy if you can help me solve my problem


    SELECT datee, client, fromto, remark, color FROM [cc].[bb].[aa] WHERE ((userID =@userID) or (authID = @userID)) AND ((color = 'red') OR (color = 'blue'))
    Thank You

  2. #2
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Simple SQL select query

    If you do this does it work?

    SELECT datee, client, fromto, remark, color FROM [cc].[bb].[aa]

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  3. #3

    Thread Starter
    Frenzied Member met0555's Avatar
    Join Date
    Jul 2006
    Posts
    1,385

    Re: Simple SQL select query

    Yes it does work if i run that query

  4. #4

    Thread Starter
    Frenzied Member met0555's Avatar
    Join Date
    Jul 2006
    Posts
    1,385

    Re: Simple SQL select query

    never mind, it was an issue with one if my colors.

    thx tho

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