Table join, table join, table join. SELECT * FROM tickets LEFT JOIN person ON person.id = tickets.createdby WHERE tickets.id = 1 This only performs well when the relationship between the object and the property is 1:1. On the other hand, if the property is a collection, there's a 1:n relationship, which would generate duplicate data in the join: 1, Blue screen, Joe, Phil 1, Blue screen, Joe, Henry 1, Blue screen, Joe, Greg As you can see the "1, Blue screen, Joe" information could potentially be