SELECT [mast].[SURNAME],[mast].[FirstNames],
			dd.[Date of Birth],
			[mast].[bldgbox],[mast].[sex],
			[mast].[type],COALESCE([ut].[postcode],'') AS [postcode],COALESCE([ut].[name],'') AS [TownName],
		[pn].[DVA Number],
		[pn].[Medicare Card Number],
		[pn].[Medicare Number Suffix],
		[mast].[altsurname] AS [SurnameAlias],
		[mast].[knownname] AS [FirstnameAlias],
		[pat].[hpolicy] AS [HealthFund_Member_No],
		[pn].[War Pension Number] AS [Fund Upi No],
		[provnum].[number] AS [ServiceProviderNumber],
		[prv].[firstnames] AS [ServiceProvider_FirstName],
		[prv].[surname] AS [ServiceProvider_Surname],
		[hinsurer].[brandid] AS [HealthInsurer_Brandid],
		[pat].[hpolicy] AS [FundMembershipNumber]
	FROM dbo.[u_master] AS mast 
		LEFT OUTER JOIN dbo.[dd_Patient_Numbers] AS pn ON [mast].[MASTERID] = [pn].[MASTERID]
		LEFT OUTER JOIN dbo.[dd_Demographic_Details] AS dd ON [pn].[MASTERID] = [dd].[MASTERID]
		LEFT OUTER JOIN dbo.u_town AS ut ON [mast].FK_TOWN_TOWNID = ut.TOWNID 
		INNER JOIN dbo.[u_patient] AS pat ON mast.[masterid] = [pat].[fk_master_masterid]
		LEFT OUTER JOIN dbo.[u_provnum] AS provnum ON mast.[fk_leadprov_providerid] = [provnum].[fk_provider_providerid]
		LEFT OUTER JOIN dbo.[u_provider] AS prv ON [provnum].[fk_provider_providerid] = [prv].[providerid]
		LEFT OUTER JOIN [dbo].[u_org] AS hinsurer ON [pat].[fk_hinsurer_masterid] = [hinsurer].[fk_master_masterid]
	WHERE [mast].[MASTERID] = @patientId

quote:

---

Originally posted by Peso

I agree the plan is the same. I was talking about the TYPE OF JOIN the query engine was selecting.

---

E 12°55'05.25"
N 56°04'39.16"

---