select f.name, nr.resource name from ca owned resource as nr left join ca resource family as f on f.id = nr.resource family ca resource family.name ca owned resource.resource name Hardware.Workstation NBK65320 Software.Application CA SERVICE DESK Hardware...