Posted by jehnich on May 7, 2009 at 2:34am
I’ve posted a question how to accomplish a join on 3 tables using Views2 on the Drupal forum: http://drupal.org/node/453992, but haven’t got any replies.
So I’m now asking for some help from my Aussie community, or especially my Sydney community – any hint would be greatly appreciated!
Cheers,
Irene
Comments
Don't use views?
Hey Irene,
I haven't tried doing a 3 way join with views before, but I might throw out the idea of not using views for what you need to do. Keep in mind that views is really aimed at providing a user-configurable friendly way of doing a query not being a complete query builder so sometimes its still useful to just write something yourself. There may be other reasons for wanting to use views or ways to hook into views with your custom query to suit your needs, but its something to consider.
--Ryan
Ryan Cross
James Cross Construction Services
ProjectPier project management and collaboration software
--Ryan
Ryan Cross
Drupal Development Services
ProjectPier project management and collaboration software
Thanks!
Thanks, Ryan - that was exactly what we needed!
So after trying to hard, we are now using Views for the easy join with 2 tables, and for the 3rd one we've just programmed a few lines of PHP ourselves.
Thanks again!
By the way, I'll be travelling up North to the Top End (in my motorhome), so won't be attending the Sydney meetups until September - but I really appreciated last month's format, and I hope you will keep it that way!
Cheers,
Irene