How to use multiple sub-query left join in rails -

-

i having 4 table need join 4 table in rails model how can it

my join sample schema is

select * ( select id,name table1 )a left join ( select * table2 )b on a.id=b.user_id left join ( select * table3 )c on a.id=b.ord_id left join ( select * table4 )d on a.id=d.other_id

one of best features of rails don't have worry writing these types of database setups. think served going through intro activerecord:

http://guides.rubyonrails.org/active_record_basics.html

activerecord abstracts sql 1 layer, you're (in theory) not writing database-specific code. allows conceptualize database schema @ higher level, rather doing left join, inner join, etc. see here more info on various associations:

http://guides.rubyonrails.org/association_basics.html


Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more