write an another query before this and the result should have your custom field.
if the value is null use or existing query otherwise instead of using c.address1_city you need to put a another inner join between filteredincident and filteredcontact
SELECT comp.new_resolutionid, comp.new_contactid, comp.new_caseidname,
i.new_cruiseidname, i.new_shipid, i.new_bookingidname,
comp.new_value, comp.new_subjectidname, c.address1_name, c.address1_line1,
c.address1_line2, c.address1_line3,
c.address1_city, c.address1_county, c.address1_country, c.address1_postalcode,
I.TicketNumber as title, s.new_initials
from Filterednew_resolution AS comp
INNER JOIN FilteredIncident i ON comp.new_caseid
= i.incidentid INNER JOIN
FilteredContact c ON c.contactid
= i.new_thirdpartycontact
INNER JOIN Filteredsystemuser AS s ON i.ownerid
= s.systemuserid
If you find this post helpful then please "Vote as Helpful" and "Mark As Answer". Amreek Singh Senior CRM Consultant CDC Praxa Sydney, Australia
http://mscrmshop.blogspot.com
http://crm2011usersettings.codeplex.com
