Hi,

I have this SQL:

select dbo.claimitemstatus(clm_forwarded
			,cit_received
			,(select com_overduedays
				from companies
					inner join Clients on cli_comfk = com_pk
					inner join Claims subclaims on clm_clifk = cli_pk
				where subclaims.clm_pk = claims.clm_pk)) as statusfk
	from ClaimItems inner join Claims on cit_clmfk = clm_pk
	having statusfk = 3

But I get a syntax error:

Msg 207, Level 16, State 1, Line 9
Invalid column name 'statusfk'.

How can I refer to the statusfk field?