Displaying 1 result from an estimated 1 matches for "date_of_arrest".
2006 Jul 21
0
[Slightly OT] Need Query Help
...How do I go
about this?
I have been using a find_by_sql query out of the client.rb that looks
like:
SELECT c.f_name AS f_name, c.l_name AS l_name, c.gender AS gender,
c.race AS race, c.dob AS dob, c.address AS address, c.city AS
city,
c.state AS state, c.zipcode AS zipcode, m.date_of_arrest AS
date_of_arrest,
ch.name AS charge_name, t.classification AS charge_type,
t.classification_level AS charge_level, t.max_fine AS max_fine,
t.min_jail_time AS min_jail, t.max_jail_time AS max_jail
FROM clients AS c
LEFT JOIN matters AS m ON c.id = m.cli...