quote:

---

"SELECT ReferenceNumber,
(SELECT TOP (1) MODIFIED_DATE
FROM Table_FOLLOW_UP
WHERE (REFERENCENUMBER = Table_Customer_Record.ID)
ORDER BY ID DESC) AS LAST_FOLLOW_UP_DATE,
(SELECT TOP (1) REMARKS_STATUS
FROM Table_FOLLOW_UP AS Table_FOLLOW_UP_1
WHERE (REFERENCENUMBER = Table_Customer_Record.ID)
ORDER BY ID DESC) AS LAST_FOLLOW_UP_STATUS,
Company_Name, Contact_Person, Email_Address, Line_of_Business, Telephone_No, Mobile_No, Fax_No, Address, Area, Sales_Representative,
Credit_Limit, Remaining_Balance, Website, Terms, Mode_of_payment, Type_of_payment, Local_Service, Site_Service, Member, Sales_End_User, Sales_Corporate,ID, Internet_Cafe, ACTIVE
FROM Table_Customer_Record
ORDER BY ID
"

---

SELECT		tcr.ReferenceNumber,
		f.MODIFIED_DATE AS LAST_FOLLOW_UP_DATE,
		f.REMARKS_STATUS AS LAST_FOLLOW_UP_STATUS,
		tcr.Company_Name,
		tcr.Contact_Person,
		tcr.Email_Address,
		tcr.Line_of_Business,
		tcr.Telephone_No,
		tcr.Mobile_No,
		tcr.Fax_No,
		tcr.Address,
		tcr.Area,
		tcr.Sales_Representative, 
		tcr.Credit_Limit,
		tcr.Remaining_Balance,
		tcr.Website,
		tcr.Terms,
		tcr.Mode_of_payment,
		tcr.Type_of_payment,
		tcr.Local_Service,
		tcr.Site_Service,
		tcr.Member,
		tcr.Sales_End_User,
		tcr.Sales_Corporate,ID,
		tcr.Internet_Cafe,
		tcr.ACTIVE
FROM		dbo.Table_Customer_Record AS tcr
OUTER APPLY	(
			SELECT TOP(1)	x.MODIFIED_DATE,
					x.REMARKS_STATUS
			FROM		dbo.Table_FOLLOW_UP AS x
			WHERE		x.REFERENCENUMBER = tcr.ID
			ORDER BY	x.ID DESC
		) AS f(MODIFIED_DATE, REMARKS_STATUS)
ORDER BY	tcr.ID;