SQL Server Multiple JOINS with Table Value Function - query never ends

I have a query with 4 joins using a table value function to get the data and when I execute it the query never ends. Issue Details  - Table value function      CREATE FUNCTION [dbo].[GetIndicator]  (            @indicator varchar(50),       @refDate datetime ) RETURNS  TABLE AS RETURN SELECT T1.Id ,T1.ColINT_1, T1.ColNVARCHAR_1 collate DATABASE_DEFAULT as ColNVARCHAR_1 ,T1.ColNVARCHAR_2 ,T1.ColSMALLDATETIME_1, T1.ColDECIMAL_1, T1.ColDECIMAL_1 FROM TABLE2 T2 JOIN TABLE3 T3 ON T2.COLFKT3 = T3.Id AND T3.ReferenceDate = @RefDate AND T3 ...