select with a subquery

gistfile1.txt

			select p.proposalname, p.proposalid, p.createdDate, u.lname, u.fname, p.clientid, c.clientname, cust.customername, ct.lname + ', ' + ct.fname as contactname,
					e.eventname, e.eventid, (
						select top 1 activityDate
						from proposalActivity
						where proposalid = <cfqueryparam value="#arguments.proposalid#" cfsqltype="cf_sql_integer">
						and contactid > 0
						order by activityDate desc
					) as activityDate
			from proposals p
      etc etc etc