I want to select values from two tables.
I was trying to use the DataObject::get syntax.
DataObject::get("ccProjects", "ccProjects.memberID = $memberID",''," left join ccImages on ccProjects.ID = ccImages.ProjectId"))
The page runs but I'm not sure why I can't get all values to output in template. The only value that outputs is the Name field from the ccProjects table. The ccImages table has a column named Name too. How do I output that field in the template?
This is all going on in a method of the ccProjects class and is referenced in the template by:
<% control getccProjects %>
<a href="#">$Name</a>
<% end_control %>