Need help with the following query. The distinct keyword doesn't seem to be
working for me.
select distinct
person_id,
person,
person_email,
applydate
from (
SELECT distinct
person.id AS person_id,
person.first_name + ' ' + person.last_name AS person,
person.email AS person_email,
j_detail.ip_address AS ip_address,
j_detail.date AS applydate
FROM person,
j_detail
WHERE j_detail.job_id = #url.id#
AND j_detail.candidate_id = person.id
)
derivedtbl
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231396
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
