The correlation name 'MR' is specified multiple times in a FROM clause
sql-server
Solution
You must use a different alias for each join of K_RT_MasterRetailStores.
Problem
``` Create PROCEDURE [dbo].[K_RT_FixedAsset] @fromdate datetime, @todate datetime AS BEGIN SET NOCOUNT ON; select convert(varchar,FT.date,103)as date, MR.branch as frombranch,PD.productname as product,FT.vehicleno,FT.dcno,FT.tobranch from K_RT_FixedAssetTransfer FT inner join K_RT_MasterRetailStores MR on MR.sno = FT.frombranch inner join K_RT_ProductDetails PD on PD.sno=FT.product inner join K_RT_MasterRetailStores MR on MR.sno = FT.tobranch where FT.date between @fromdate and @todate END ```