I am testing on the AdventureWorks database (the OLTP version, not the data warehouse version). This version has the 'dbo' schema and other schemas to. I am trying to run a simply query and I get an error stating invalid object name 'HumanResources.Employee.BusinessEntityID'. Here is the code:
This doesn't work either:
When I run this code, I get a result set:
- Why does the first query not work?
- How can I query the BusinessEntityID column if these queries don't work?
I am in the AdventureWorks2017 database.