why this short sql not ok? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

why this short sql not ok?

Author

Topic

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2014-03-21 : 09:46:42

I am getting error here: Msg 207, Level 16, State 1, Line 3
Invalid column name 'FACILITY_NPI'.

not sure why the 'f' is plainly there.

SELECT f.FACILITY_ID, count(f.FACILITY_ID) C
FROM [PBM].[T_CHARGES] A
Inner join PBM.FACILITY f on A.FACILITYNPI = f.FACILITY_NPI
INNER JOIN PBM.USER_FACILITY uf ON f.FACILITY_ID = uf.FACILITY_ID

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-03-21 : 10:34:19

[code]SELECT f.FACILITY_ID,
COUNT(f.FACILITY_ID) AS C
FROM [PBM].[T_CHARGES] AS a
INNER JOIN PBM.FACILITY AS f ON f.FACILITY_NPI = a.FACILITYNPI --<--- a.FACILITY_NPI or f.FACILITYNPI ???
INNER JOIN PBM.USER_FACILITY AS uf ON uf.FACILITY_ID = f.FACILITY_ID;[/code]

Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources