The column prefix ''dbo'' does not match with a table name or alias name used in the query.

• dba321

  Hall of Fame

  Points: 3917

  More actions

  April 16, 2007 at 1:21 pm

  #172986

  Not sure what I'm doing wrong here...but in my function I have

        DECLARE @CountryName VARCHAR(50)

   

        SELECT @CountryName =

        Descrip FROM [myDB].[dbo].[syCountry]

        WHERE [myDB].[dbo].[syCountry] = @CountryID

   

        RETURN(@CountryName)

  Error:

  The column prefix 'dbo' does not match with a table name or alias name used in the query.

• Chuck Rivel

  SSCrazy

  Points: 2991

  More actions

  April 16, 2007 at 2:08 pm

  #700775

  are you missing the column name in the where clause?

  WHERE [myDB].[dbo].[syCountry].columnname = @CountryID