select opr.operatorId, opr.companyName, opr.address, opr.city, opr.lastInteractionDate, coalesce( seg.clientSegId, 0 ) oprSegment, coalesce( seg.description, 'Unknown' ) description from tbl_OPR_ClientOperators opr left outer join tbl_OPR_ClientSegments seg on seg.clientSegId = opr.oprsegment where opr.ownerId = 14 and opr.fsltablecode = 'BRO' and opr.state = 'NY' order by operatorId desc #htmleditformat( companyName )# #htmleditformat( address )# #htmleditformat( city )# #lsdateformat( lastInteractionDate, "MM/DD/YYYY" )# #htmleditformat( description )#