Implement functionality for getting projects and canvases

I don't get your problem. This IS a join since this query operates over two tables and merges the information.