Hi Jeremy, I want to add more conditions to inner join after ON but it appends and treat as array instead of merging conditions.
Let me show you the full query builder: DB[:full_paths]. select(:id, :subject). cross_join(:pattern). where{{:idx=>cardinality(:pattern)}}. with(:pattern, DB.select{string_to_array("folder_2/SUB iso", '/')}, :args =>[:pattern]). with_recursive(:full_paths, DB[:folders]. select(:id, :base_folder_id, :subject, Sequel[1].as(:idx)). cross_join(:pattern). where(:user_id=>24). where{subject.ilike(pattern.sql_subscript(1))}, DB[Sequel[:folders].as(:x)]. select(:id, :base_folder_id, :subject, Sequel[:idx] + 1). cross_join(:pattern). join(Sequel[:full_paths].as(:y), :id=>:base_folder_id){Sequel.expr{x[: subject].ilike(pattern.sql_subscript(idx+1))}} ) What I want to add here: (last line) join(Sequel[:full_paths].as(:y), :id=>:base_folder_id){Sequel.expr{x[: subject].ilike(pattern.sql_subscript(idx+1))}} more conditions which is: x.user_id = 24 Currently this line produces: INNER JOIN full_paths AS y ON ((y.id = x.base_folder_id) AND (x.subject ILIKE pattern[(idx + 1)] ESCAPE '\\')))) What I want is: INNER JOIN full_paths AS y ON ((y.id = x.base_folder_id) AND (x.user_id = 4) AND (x.subject ILIKE pattern[(idx + 1)] ESCAPE '\\')))) How can i make multiple conditions for this join (not where but via ON) Thanks, Gencer. -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to sequel-talk+unsubscr...@googlegroups.com. To post to this group, send email to sequel-talk@googlegroups.com. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.