Displaying 1 result from an estimated 1 matches for "bs_id".
Did you mean:
bus_id
2006 Mar 07
1
Find By SQL + multiple tables
Hello all. I am trying to get the following SQL to work in Ruby on rails
and Oracle.
SELECT bugsheet.*, bugcomplete.bc_time FROM bugsheet, bugcomplete WHERE
bugsheet.bs_id = bugcomplete.bc_id AND bugsheet.bs_patchrel like
''5.1.12-B4%'' ORDER BY bs_cdate DESC, bc_time DESC
If I type that into an SQL program it works fine, if I try and use the
following in RoR:
Bugsheet.find_by_sql["SELECT bugsheet.*, bugcomplete.bc_time FROM
bugsheet, bugcom...