Hi,
Let's say I'm joining three tables like so (this is a many-to-many
relationship between TableA and TableC, where TableB is the join table):
TableA.join(TableB, :a_id => :a_id).join(TableC, :c_id =>
:c_id).filter(:table_c__field1 => 1, :table_c__field2 => 1,
:table_b__field3 => 1)
This works perfectly well to select all the fields from all the tables
("SELECT * FROM ...), but how do select just the fields from TableA
("SELECT table_a.* FROM...)
The obvious follow up: can this be done just with associations? I have the
many_to_one set up in my TableA model so that it can, for instance,
retrieve all the associated records from TableB and TableC, but I'm not
sure how it would work just to filter TableA. The twist is that the fields
it needs to be filtered on exist in al the table which is why they have to
be spelled out (":table_c__field1 => 1") in the statement above.
Thanks
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sequel-talk/-/Uk3XU2XJYgcJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
