Msg 1013 Select not working -- Correlation names? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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

Msg 1013 Select not working -- Correlation names?

Author

Topic

Conjurer
Starting Member

30 Posts

Posted - 2006-04-07 : 15:16:30

I am trying to run a select query and getting the following error:
Server: Msg 1013, Level 15, State 1, Line 12
Tables or functions 'PatientVisit' and 'PatientVisit' have the same exposed names. Use correlation names to distinguish them.

Not sure what I am doing wrong! Here is the query. Can anyone point me int the right direction?

SELECT     Batch.Entry AS [Date Of Entry], PatientProfile.[Last] + ', ' + PatientProfile.[First] AS Name, 
                      MedLists.Description AS [Adjustment Type], PatientVisit.TicketNumber, PatientVisitProcs.Code AS [Procedure Code], 
                      TransactionDistributions.Amount AS [Adjustment Amount], PatientVisitProcs.DateOfServiceFrom, 
	          ISNULL(CONVERT(varchar(255), Transactions.Note), ' ') AS Notes, 
	          DoctorFacility.DotID, DoctorFacility.ListName as DrName, PatientVisit.DoctorID as DrID
FROM         PaymentMethod 
INNER JOIN    VisitTransactions ON PaymentMethod.PaymentMethodId = VisitTransactions.PaymentMethodId 
INNER JOIN    Transactions ON VisitTransactions.VisitTransactionsId = Transactions.VisitTransactionsId 
INNER JOIN    TransactionDistributions ON Transactions.TransactionsId = TransactionDistributions.TransactionsId 
INNER JOIN    Batch ON PaymentMethod.BatchId = Batch.BatchId 
INNER JOIN    PatientVisit ON VisitTransactions.PatientVisitid = PatientVisit.PatientVisitId 
Inner Join     PatientVisit ON DoctorFacility.DoctorFacilityID = PatientVisit.DoctorID
INNER JOIN    PatientProfile ON PatientVisit.PatientProfileId = PatientProfile.PatientProfileId 
INNER JOIN    MedLists ON Transactions.ActionTypeMId = MedLists.MedListsId 
INNER JOIN    PatientVisitProcs ON TransactionDistributions.PatientVisitProcsId = PatientVisitProcs.PatientVisitProcsId

Any Idea on how to fix it up? Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-07 : 15:26:07

You joined to PatientVisit twice and didn't provide different alias for each. In fact, you aren't using aliases at all it appears. Here's an example:

SELECT t.Column1, z.A
FROM Table1 t
INNER JOIN Table2 z
ON t.ID = z.ID

Tara Kizer
aka tduggan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources