• 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]