I didn't see the visual joins that you can do in MS Access, though I just looked at the first page. If it's anywhere near that useful this product is way overdue.
Yup - if you grab columns from multiple different connected tables (or schemas) the join will happen automatically for you and can be adjusted to different paths. This is actually a really hard problem, especially since 70% of datasources these days don't have foreign key information and we have to detect that automatically.
