Exposed Names - 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

Exposed Names

Author

Topic

alscho
Starting Member

1 Post

Posted - 2008-11-24 : 10:16:29

I am getting the error message:
Tables or functions 'WSH18Week.dbo.TblAppointmentsWithPPI' and 'WSH18Week.dbo.TblAppointmentsWithPPI' have the same exposed names. Use correlation names to distinguish them.

From the code:
UPDATE WSH18Week.dbo.TblAppointmentsWithPPI
SET WSH18Week.dbo.TblAppointmentsWithPPI.PPI = WSH18Week.dbo.TblMaxRefDate.ReferralID
FROM WSH18Week.dbo.TblAppointmentsWithPPI
INNER JOIN WSH18Week.dbo.TblAppointmentsWithPPI
ON WSH18Week.dbo.TblMaxRefDate.F_PATID = WSH18Week.dbo.TblAppointmentsWithPPI.CRN
WHERE (WSH18Week.dbo.TblAppointmentsWithPPI.PPID Is Null
AND WSH18Week.dbo.TblMaxRefDate.F_LSPEC = WSH18Week.dbo.TblAppointmentsWithPPI.SPEC )
OR (WSH18Week.dbo.TblAppointmentsWithPPI.PPI Is Null
AND (WSH18Week.dbo.TblMaxRefDate.F_LSPEC = 'TO' Or WSH18Week.dbo.TblMaxRefDate.F_LSPEC = 'FRAC')
AND (WSH18Week.dbo.TblAppointmentsWithPPI.SPEC = 'TO' Or WSH18Week.dbo.TblAppointmentsWithPPI.SPEC = 'FRAC'));

Where am I going wrong?
Thanks
Allison

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-24 : 10:22:01

We can't tell which column is which. This is an example of how to alias you tables.
You will have to change the alias for every column to make the query work.

UPDATE		x
SET		x.PPI = WSH18Week.dbo.TblMaxRefDate.ReferralID 
FROM		WSH18Week.dbo.TblAppointmentsWithPPI AS x
INNER JOIN	WSH18Week.dbo.TblAppointmentsWithPPI AS y ON y.F_PATID = x.CRN
WHERE		x.PPID Is Null 
		AND y.F_LSPEC IN (x.SPEC, 'TO', 'FRAC')
		AND y.SPEC IN ('TO', 'FRAC')

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources