Post reply

Syntax problem - Msg 4145

  • June 14, 2010 at 1:34 am

    #143584

    I wrote this code :

    select Name, count(ID)

    from Players Join Brands on PlayerID

    where UnsubscribeDate between '2009-01-01' and '2010-01-01'

    group by ID, Name

    and i get this error message:

    Msg 4145, Level 15, State 1, Line 3

    An expression of non-boolean type specified in a context where a condition is expected, near 'where'.

    tried to rap my head around it, could use some help..

    thanks.

  • June 14, 2010 at 1:54 am

    #1179693

    best guess..

    this...

    from Players Join Brands on PlayerID

    should be

    from Players Join Brands on Players.PlayerID = Brands.PlayerId

    HTH


    Clear Sky SQL
    My Blog[/url]

  • June 15, 2010 at 12:56 am

    #1180217

    It works, thanks 🙂

  • June 15, 2010 at 2:10 am

    #1180242

    Good stuff.

    Hope you understand your mistake.


    Clear Sky SQL
    My Blog[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply