Query Error

Hi all,

I'm a new guy trying to tutor myself on MRS and I'm using

SQL05DEV on my desktop. I managed to finally get connected to

AdventureWorks db, but when I run this query:

SELECT S.OrderDate, S.SalesOrderNumber, S.TotalDue, C.FirstName, C.LastName
FROM HumanResources.Employee E INNER JOIN
Person.Contact C ON E.ContactID = C.ContactID INNER JOIN
Sales.SalesOrderHeader S ON E.EmployeeID = S.SalesPersonID

=====================================================

I get this error:

TITLE: Microsoft Report Designer

An error occurred while executing the query.
Invalid object name 'HumanResources.Employee'.

ADDITIONAL INFORMATION:

Invalid object name 'HumanResources.Employee'. (Microsoft SQL Server, Error: 208)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476

--

Any tips for troubleshooting?

How would Icheck to see if the human resources table even exists?

Thanks,

>Scott

Hi,

* Have you check if you have change database name !!!?

SELECT S.OrderDate,

S.SalesOrderNumber,

S.TotalDue,

C.FirstName,

C.LastName

FROM adventureworks.humanresources.Employee E

INNER JOIN

adventureworks.person.Contact C

ON E.ContactID = C.ContactID

INNER JOIN

adventureworks.sales.SalesOrderHeader S

ON E.EmployeeID = S.SalesPersonID

this runs fine on my machine.

|||

Hemantgiri,

Thanks for responding and showing me your SQL.

I tried it on my machine and no luck. I get the error below when I run

the SQL that works on your machine. Do you have any suggestions?

I seem to have something misconfigured on my machine.

Thank You again,

Scott

TITLE: Microsoft Report Designer

An error occurred while executing the query.
Invalid object name 'adventureworks.humanresources.Employee'.

ADDITIONAL INFORMATION:

Invalid object name 'adventureworks.humanresources.Employee'. (Microsoft SQL Server, Error: 208)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3033&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476

|||

Hi,

Are you able to see the database in SSMS and able to open any table !!!

Hemantgiri S. Goswami