Thread: Correlation

> HI All, While trying to execute this view in sql, i got the error message as,"Msg 1013, Level 16, State 1, Procedure sale1, Line 3 The objects "dbo.INV1" and "dbo.INV1" in the FROM clause have the same exposed names. Use correlation names to distinguish them." How do i correct it? I am unable to figure this out. Please suggest. USE [DBNAME] GO /****** Object: View [dbo].[sale1] Script Date: 11/14/2009...

> You are joining dbo.INV1 twice so you have to give different alias names for them. For example you can do it like this: dbo.INV1 as Inv1_Doc ON dbo.OINV.DocEntry = Inv1_Doc .DocEntry LEFT OUTER JOIN dbo.INV1 as Inv1_Base ON dbo.ODLN.DocEntry = Inv1_Base .BaseEntry Now you have use that aliases in your select list and WHERE-clause instead of dbo.INV1 No, you're never too old to Yak'n'Roll if you're too young to die.