• I'm using SQL Server 2008 R2. However, I think the database might be configured to run as SQL Server 2005 (9.0).

    The expected result that I want is:

    ProductID ProductName

    1 Keyboard

    2 Mouse

    Sorry for the confusion.